Hi, is there an Expression where I could conv...

expressions
(Chin-Beng Tan) #1

Hi, is there an Expression where I could convert a datetime into its number format?

(Aleksi Alkio) #2

The date you can convert with… HOUR(TODAY()-“12/30/1899”)/24

(Thomas Varghese) #3

Wow! Very useful expression and is so simple and logical but not easy to come up with requires some thinking …

(Chin-Beng Tan) #4

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

(Aleksi Alkio) #5

#ERROR!