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! Go to 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!
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |