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

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.

0 3 999
3 REPLIES 3

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”)

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

You’re welcome

Top Labels in this Space