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 966
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