Is it possible to generate a UNIX Timestamp w...

(Greg Huston) #1

Is it possible to generate a UNIX Timestamp with Appsheet? Something along the lines of this? http://www.timestampgenerator.com/

I would like to have quote numbers

follow this Timestamp format, and am unsure if appsheet has this somewhere built in and I am not finding it.

(Aleksi Alkio) #2

Try with this formula. I didn’t test it but it should work.

(HOUR(DATE(NOW()) - “01/01/1970”))*3600 + (MOD(HOUR(NOW() - “01/01/1970”),HOUR(DATE(NOW()) - “01/01/1970”)))*3600 +

MINUTE(NOW() - “01/01/1970”)*60 +

SECOND(NOW() - “01/01/1970”)

(Greg Huston) #3

@Aleksi_Alkio - works like a charm! Thanks so much!

(Aleksi Alkio) #4

You’re welcome