Dates display in inconsistent format - how do i fix?

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 image

However the Inline form displays it incorrectly image

As does the Details Form image

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.

1 Like

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.

2 Likes

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.

3 Likes

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.

2 Likes

Please refer below link. this may help

1 Like