How to change export import CSV file time stamp?

[kvngo94]

Hi Guys, 

I'm living in Vietnam

I imported file at 14:20 PM vietnam time

But the column DateTime (NOW()) is showed as 7:20AM of the same date on AppSheet 

Could you help me to sync the time stamp following vietnam time ? 

[Suvrutt_Gurjar]

You may want to take  a look at the below help article

https://help.appsheet.com/en/articles/5340655-configuring-the-csv-locale

[kvngo94]

I tried changing the CSV locale to Vietnamese, but the time stamp is still not correct when importing the file

[Joseph_Seddik]

The date format that is displayed in the app, is not related to the locale of the file, or the appsheet table. It depends on the locale configured on the computer or the mobile device running the app. 

Your users can see different date formats based on the regional settings configured on their devices. You can change the regional settings on your own device and you'll see the date format change accordingly. 

If you want to see a specific date format you have two options:

1. Either, change the regional settings on your own device, 

2. or, force a specific date/time format using the TEXT() command in another column and display this formatted column in your app views. 

[kvngo94]

Hi Joseph, 

Could you please explain more of the option (2) ? 

Regarding (1), actually my laptop regional is showing as Vietnam time, but still it's showing the wrong time stamp when importing the CSV file action

[Joseph_Seddik]

Option (1), where are you seeing this please? In a view of your app? Would you please post a screenshot of this view along with a screenshot of the regional settings of the device displaying this view? Thank you!

Option (2), please read this article: TEXT(), it is well explained. Generally, you would create a new column, type Text, with the following App formula or similar: 

TEXT([dateTimeColumnName], "dd/mm/yyyy - HH:MM")

[kvngo94]

Dear Joseph,

Below is computer setting when I'm replying this

But when importing the CSV file, it's recorded as 11:56:27 (last row)

[Joseph_Seddik]

Yes, I expected that you were talking about the display in Google Sheets, not in the app. You can leave it as it is, and it will still show correctly inside the app. You do not have to change anything. 

If for any reason you want also to change the date display in Google Sheets (which does NOT affect the app), then you'll have to change the Regional Settings of your google sheet itself. This is done from the menu: File --> Settings --> Regional settings, and choose Vietnam. 

[kvngo94]

I already changed it to Vietnam time zone 

But It still show wrong time stamp 12:40 I just exported,  actually now is 19:40 in Vietnam