Hi, is there an Expression where I could convert a datetime into its number format?
The date you can convert with… HOUR(TODAY()-“12/30/1899”)/24
Wow! Very useful expression and is so simple and logical but not easy to come up with requires some thinking …
@Aleksi_Alkio thanks Aleksi. my bad for not giving sufficient context.
what I was trying to do was to replace the Sheet’s formula into Appsheet.
Google Sheet formula =TO_PURE_NUMBER(NOW())
The output should be something like… “43323.53656”