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

[Doron_Assis]

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]

It’s this Google sheets

[Gil_Littman_App]

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

[Doron_Assis]

Found the solution,

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

[Grant_Stead]

@Doron_Assis that’s what I was thinking