Date YYYY/MM/DD

[hermanusgerber]

The date format must be YYYY/MM/DD in the app. I don't want to create a Text Virtual column, I just want the formats to be like this everywhere...

I've changed the Sheet locale to UK as well as AppSheet locale to UK and made all the date columns in the Sheet YYYY/MM/DD.

[hermanusgerber]

When I fill out the form the date format is YYYY/MM/DD, but after the form is saved it is shown as DD/MM/YYYY:

[jyothis_m]

The Date Format Displayed on the Mobile App will be according to the Languange Setting Selected on the device. For e.g. below setting will display Date in DD/MM/YYYY 

[hermanusgerber]

I've changed the Sheet locale to UK as well as AppSheet locale to UK and made all the date columns in the Sheet YYYY/MM/DD, but after the form is saved the date is still displayed as DD/MM/YYYY

[jyothis_m]

The setting i mentioned above was the Android Language Setting. Not the Appsheet or google sheet Locale Setting

[hermanusgerber]

Okay, thank you. Do you know if there is a language setting that has the date format of YYYY/MM/DD?

[jyothis_m]

pls see the link below

Date format by country - Wikipedia

[hermanusgerber]

Also, the date format on my iPhone is YYYY/MM/DD, but in the Appsheet app (iOS) the date is still displayed as DD/M/YYYY:

[jyothis_m]

May be you can try changing Region Setting

[hermanusgerber]

Tried with no luck 😞

[Steve · Accepted solution]

It is not possible to establish a custom date format without the use of a Text column. The best you can do is change the locale to get the locale's date format.