Forum Discussion
Solved
Calculate Difference Between Two Date/Time Values Like in Excel
Hi all, I searched this forum to find out how to calculate the difference between two date and time values and there are plenty of post regarding this topic. (I think) I understand how DATEDIFF work...
OK, I got it - my fault! I found the solution a minute after I posted this topic.
A new Custom Column has to be added in Edit Query mode. Then I can simply subtract two date/time values and change the result column data type to Decimal Number.
Best regards,
M.
OK, I got it - my fault! I found the solution a minute after I posted this topic.
A new Custom Column has to be added in Edit Query mode. Then I can simply subtract two date/time values and change the result column data type to Decimal Number.
Best regards,
M.
Hi there
Can you please expand on this two processes you mentioned
1) How did you subtract two date/time value ? did you use "DATEDIFF" ?
2) How did you "change the result column data type to Decimal Number?