What goes wrong with date and time

[erwblo]

I have a column with dates mm/dd/yy. I have a Google Sheet and an Appsheet app with Language locale US. But I have an app that shows some mm/dd/yy and some dd/mm/yy. What can I do wrong?

[Heino_Matthee]

I think it comes from the setting in your google sheet. Make sure the date setting in google sheets is the way you want it.

[erwblo]

Yeah, I did that. It’s locale US, like is Appsheet.

[Heino_Matthee · Accepted solution]

Yes but the format of the columns could be different than the setting. Check the format in the sheet of the columns that are misbehaving. Otherwise I don’t know what could be the issue

[erwblo]

Thanks, did that and now it is all fine!