calculating duration in days
Hello - I am trying to calculate duration in days, which I have found the formula easily. However the math does not seem to be working correctly. For example, my team worked from 3/12-3/14...T...
Forum Discussion
This didn't work for me. Failed due to an argument in the function. Can you help? Below is what I tried. What did I do wrong? The two date fields referenced are named as such. Data type=Date/Time.
The function ToTimestamp can be used with the following arguments:
ToTimestamp (Date d).
ToTimestamp (Date d, TimeOfDay t).
(ToTimestamp([First Attempt Date/Time])-ToTimestamp([Date/Time Escalated]))+Days(1)
The function ToTimestamp can be used with the following arguments:
ToTimestamp (Date d).
ToTimestamp (Date d, TimeOfDay t).
(ToTimestamp([First Attempt Date/Time])-ToTimestamp([Date/Time Escalated]))+Days(1)