Solved: Time difference when importing CSV - Page 2

Emily · 02-21-2022 02:21 AM

Hello.
Thank you for your help.

I noticed something strange.
The default expression in creation date column contains the NOW () expression.

If you import the CSV in that state, the time 9 hours ago will be automatically entered in the column.
My current timezone is Tokyo, so I think it was automatically entered in UTC time.

Is there a way to automatically enter the local time?

Hayato_Ito

Thank you for your responses.

I updated my sample and test it, worked ideally.

https://www.youtube.com/watch?v=6SHiaMpJN5M

I didn't know that the context ("host") returns "server". This teaching is very helpful for me!

I also thought it would be better if there was an explanation for this concept somewhere in the help.

https://help.appsheet.com/en/articles/5340448-import-a-csv-file-for-this-view
Example: This action is processed on the server side.

https://help.appsheet.com/en/articles/2357321-now
Example: According to the time zone of the execution host. See also Context function.

View solution in original post