Convert date to number

Dear Community:

In Excel there is the DATEVALUE formula that converts a date into a number. For example DATEVALUE (“1/1/2008”) returns 39448.
Is there a similar formula in AppSheet?

Thanks in advance.

Solved Solved
0 5 3,247
1 ACCEPTED SOLUTION

Thanks a lot @Markus_Malessa. Finally, I had to rewrite the expression you suggested to get the same result as the Google DATEVALUE formula:
HOUR([FechaTurno]-DATE(“1/1/1900”))/24+2

Thanks!

View solution in original post

5 REPLIES 5
Top Labels in this Space