Problem with the localization for the Dates between Appsheet and Salesforce

AppSheet AppSheet Q&A
1

Hello,

both in Salesforce and AppSheet I’ve set the Italian Locale (I’ve also checked that every table that I’ve imported were set to Italian Locale).

But everytime I view a record with some dates on it, I see the dates in format MM/DD/YYYY, instead of DD/MM/YYYY.

For example, I’ve created a new row with this date 2/5/2023 (2nd of May) and at first it seems correct, but after few seconds (after the row has been commited to Salesforce), AppSheet “convert” the date in 2/5/2023 (5th of February).

It is affecting all of my project, what am I missing? What else should I check?

In the form, while I’m inserting the row, I see the date format correctly:

VESmik_0-1682675511375.png
VESmik_0-1682675511375.png382×282 10.1 KB

Just after the “Save”, in the recap detail, the date format is incorrect, but at least AppSheet reckon it’s May

VESmik_1-1682675580502.png
VESmik_1-1682675580502.png341×268 6.66 KB

Few seconds later:

VESmik_2-1682675647280.png
VESmik_2-1682675647280.png304×211 6.38 KB

Thank you very much!

2
Locale support in AppSheet - AppSheet Help
Consider that the locale used by the device/browser affects how the data is shown, which is different as how it’s saved
3

Hi @SkrOYC ,

I’ve checked everywhere for the locale: device, browser, AppSheet, Salesforce, but everywhere is set the Italian one. I really don’t know why I do see the American one.
It’s really affecting my app: if I select from the calendar view the 3rd of May, on Salesforce is set correctly, in AppSheet is saved as the 5th of March.
And also, all of the dates have the “wrong” format mm-dd-yyyy

4

Check this with support