I have a Google Sheet with a column formatted as a date. Today’s date displays correctly
Expense Date
28/05/2020
The form to add a record likewise displays the record correctly
However the Inline form displays it incorrectly
As does the Details Form
I’ve checked the settings and all appears to be correctly set for Australia but the application of the format seems to be inconsistent. Any suggestions
Ensure your Google sheet’s locale is also set correctly.
Is this what I should be looking for? If so it’s correct
Hmm, well the display is pretty much always a locale thing. But if that is all setup right, then I’m not sure on to the why it is happening. As a temp workaround, if needed sooner rather than later, create a virtual column with an app formula of TEXT([YourDateColumn], "dd/mm/yyyy")
. Then using the Show If, make the real column visible only on the form for editing, and the VC everywhere else for display.
And maybe also send an email to support@appsheet.com. Might be a bug in locales on their end.
To add to guidance by @Bahbus, please consider following as well
I believe there are 5 possible locale settings. Google sheets ( or back end database, Spreadhseet settings as picture shared by you), the date format of the columns in back end spreadsheet, locale settings in the AppSheet editor under Data --> Tables , the date setting of the device (mobile , tablet or PC ) itself where you are browsing/ editing the app and finally the browser locale setting.
In an app, I have all these 5 settings to dd/mm/yyyy time zones in the PC where I am editing the app. However I observe that in the detail and table view of the AppSheet editor I am getting dates in mm/dd/yyyy format as you mentioned.
However in another mobile device when I browwse that app, where I have device’s date setting to dd/mm/yyyy format, the dates are displaying in dd/mm/yyyy format in all three views.
So, in summary , I request you to once verify the date display in a different device than your AppSheet editor.
If the problem still persists, @Bahbus’s I believe workaround is a useful one or you may wish to contact AppSheet support team.
The date formats are very inconsistent. The screen shots I sent are from my PC but on my Android phone they are correct. My PC is set to Australia Date and Time format so I may leave this question here till the AppSheet team come on line and see if they have an answer. If not I will raise the email to them as suggested.
Please refer below link. this may help
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |