About Timestamp, I'm using Timestamps (Chang...

(Doron Assis) #1

About Timestamp,

I’m using Timestamps (ChangeTimestamp) in my app. the only problem is the Timestamp is MM/dd/YYYY format, and I need to add or substract the Timestamp dates to/from other dates in dd/MM/YYYY formats.

(Changing the other dates to MM/dd/YYYY is not an option, I need the dd/MM/YYYY format).

Is there a way to change the setting of the ChangeTimestamp function ?

(Grant Stead) #2

It’s this Google sheets

(Gil Littman [AppSheet]) #3

@Doron_Assis You could use a virtual column the convert the dd/MM/YYY date to MM/dd/YYYY

(Doron Assis) #4

Found the solution,

I had to change the Speardsheet time setting (Google sheets) in file -> setting

(Grant Stead) #5

@Doron_Assis that’s what I was thinking