I have a datetime field
field1 which i am populating using
At some point later i want to know the difference between
field1 in number of days.
DATETIMEVALUE(NOW()) - DATETIMEVALUE(field1), but it does not seem to be correct.
I am storing this result in a number field which can store 6 decimal places. But when i multiply the value by 60*24, it does not return correct result.
If the difference is 12 hours between
field1, I want the field to have .5 as value. If the difference is 6 hours, it should have .25