The Date, Locale and App Formula I use the Da...

[Warang_L]

The Date, Locale and App Formula I use the Date format dd/mm/yyyy, the year is BE

like 2561and it works by setting Locale in Google Sheet and App.

But when I created the App formula with Year([Date]), the year turn to AD 2018 to the Google Sheet. So what should I do? Thanks

[David_Ackling-J]

Hi, The next thing for you to check, I think, might be to go into the settings on your browser itself. When I had a similar problem I went into Chrome Settings, and deleted US English from the Languages list, making UK English the only language on the list. This fixed the date format localisation problem for me in Appsheet. Good luck.