Forum Discussion
Solved
Calculating date/time difference
Hello, I would like to calculate the difference between 2 date/time value (one is an additional column, the other is a measure). I need to see the result in days, but in deci...
Try this
New column = (AIRActionHistory[ScanImportDate]-AIRActionHistory[FirstActionDate])+(((HOUR(AIRActionHistory[ScanImportDate])-hour(AIRActionHistory[FirstActionDate]))+(((MINUTE(AIRActionHistory[ScanImportDate])-MINUTE(AIRActionHistory[FirstActionDate]))/60))/24)
I dont think you need the extra .[Date] at the end of things
Try this
New column = (AIRActionHistory[ScanImportDate]-AIRActionHistory[FirstActionDate])+(((HOUR(AIRActionHistory[ScanImportDate])-hour(AIRActionHistory[FirstActionDate]))+(((MINUTE(AIRActionHistory[ScanImportDate])-MINUTE(AIRActionHistory[FirstActionDate]))/60))/24)
I dont think you need the extra .[Date] at the end of things
Yes, you are right. I dont need the extra .[Date] thing.
Many thanks!