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

[Chin-Beng_Tan]

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

[Aleksi_Alkio]

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

[Thomas_Varghese]

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

[Chin-Beng_Tan]

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

#ERROR!