Date and time format randomly changes

[saltyfat]

Hi.

I made a simple barcode input appsheet for inventory items, and Date column format randomly changes. 

* Translation
Timestamp | Date | Barcode | Weight | Product ID | Product Name | Location

Appsheet formula for Timestamp and Date column only has NOW() and TODAY()
YYYY-MM-DD HH:MM:SS and YYYY-MM-DD are expected format but it's keep changing.
(I tried also with TEXT(TODAY(), "YYYY-MM-DD") but it didn't work.)

Both Appsheet table localization and google sheets settings are Korean / Korean (+GMT +9)
and whole columns are same date format.

Can anyone help with this problem?
Thank you.

[Suvrutt_Gurjar]

---

@saltyfat wrote:

and whole columns are same date format.

---

Please try making all Google sheet columns as plain text type.

[saltyfat]

Thank you for the reply. Sadly it doesn't work.
It's very weird it sometimes with wrong format, and than sometimes right.

[Suvrutt_Gurjar]

My suggestion will be to continue to use the expression TEXT(TODAY(), "YYYY-MM-DD") ,\ and  make the column as text type.

I believe this will impact any new records created and those should be in uniform format of "YYYY-MM-DD" . However existing records will not change unless you edit those records individually.

[saltyfat]

For anyone further have same problem, it was locale problem between Appsheet and Google sheet server only happened in South Korea. (now it's fixed)

Temporay solution was changing locale to UK from both Appsheet table and google sheet.