Convert date to number

[ranorga]

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.

[Markus_Malessa]

I think in your analogy you should remember that Excel’s Datevalue function is based on the fact of an arbitrary start date of January 1, 1900.

To simulate something similar you could introduce a virtual column [DateValue] with an expression:

[YourActualDateColumn] - DATE("1/1/1900")

That should ideally give you the same result.

[ranorga · 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!

[22AN5]

Great! This helped me a lot to improve my app😎

[JoGT]

ranorga, eres un master, muchas gracias. 

no puedo creer que google/apsheet, no tenga una función para medir el número de dias entre dos fechas. Muchas gracias por aportación. 

[JoGT]

muchas gracias por tu aportación, 

HOUR([FechaTurno]-DATE(“1/1/1900”))/24+2

funciona perfecto!!!