TLDR: PLEASE SWITCH TO EPOCH/UNIX for date and time calculations
Currently date and time fields when converted into a number give number of days past Wednesday, 13 April 0824. Time gives hours as units.
For example
25/10/19 = 436655
09:01 = 9.02
Therefore you cannot calculate functions with both time and date for example adding the above examples together gives 436664.02, but if I add 24/10/19 (436654) to 13:01 (13.02) I get 436667.02. So the earlier date is a larger number
This is important if you want to compare date and time (is this date and time higher than that time and date, for example used to check entries are chronological in order).
I'm not sure what the reasoning is for this as the Epoch/unix system is used pretty much everywhere and solves this issue. Can you please address this!
Comments
Please sign in to leave a comment.
Howdy Mike,
Thank you for sharing this feedback! I'm glad you were able to find a workaround with my colleague Drew in Support (by multiplying the days by 24 then adding the time).
I can see how changing the method by which dates and times are converted in Calculation fields would be helpful. I will be sure to share this feedback with our Development teams.