Can anyone please tell me what happens if we subtract two date & time fields. For example I have attached a screenshot where i have calculated a field using two date & Time fields. I have ended up results in decimals. But not sure what was that.
so in my case as per screenshot i have calculated ( [Evnt End Time] - [Evnt Start Time] ) i have got result of 0.000127 is that difference of hours or mins or seconds.
Appreciate the help.
Why don't you use the function datediff so you can specify the kind of result that you're searching for ?