I get dd.mm.yyyy instead of dd/mm/yyyy

AppSheet AppSheet Q&A
,
1

Hey there,

In recent days, every time a date is entered in my apps, it’s saved in GOOGLE SHEETS as dd.mm.yyyy instead of dd/mm/yyyy. This issue occurs when I use several mobile phones and PC, even after playing with local settings. I even tried using the TEXT formula to force the necessary format.

Appsheet recognizes it as a date, but Google Sheets does not. Do you have any idea what might be causing this and how to fix it?

2

Set the column type in gSheet as a date. It’s probably set as automatic.

1 Like
3

Additionnaly, check that the Google Sheets locale is the same than your table locale in your app :slightly_smiling_face:

Aurelien_0-1696313669539.png
Aurelien_0-1696313669539.png710×442 23.5 KB

Aurelien_1-1696313872047.png
Aurelien_1-1696313872047.png662×554 24.3 KB

4

Thanks,

The column set as date, both Google sheet and appsheet set to the same locale definition. any way, I think it should not produce point intead of slash in any locale definition. that’s weird and it started only in the last days with no change made, before that it worked with no issue.

1 Like
5

Can you confirm the value written is incorrect, and this is not a displaying?

Aurelien_0-1696316644572.png
Aurelien_0-1696316644572.png238×186 3.76 KB

6

they are both the same:

Rani_M_0-1696317885696.png

7

That’s strange, I have no idea of the cause of such change.

8

What locales are you using? I checked one of my old apps that is using gSheet, and it has recorded dates with dots from 2017 with Finnish locale settings.

1 Like
9

I’m using Israel locale settings. it works fine for years and I didn’t change anything. But now I tried changing it to UK, and it worked. The date appeared as dd/mm/yyyy. So, I suppose the locale settings for Israel have recently changed in AppSheet.

10

https://support.google.com/appsheet/answer/11579290?hl=en&sjid=9245030120130191389-EU#:~:text=Percent%20Group%20Separator%3A%20%2C-,Hebrew%20(Israel),-Id%3A%20he%2DIL

2 Likes