Forum Discussion

turbea's avatar
turbea
New Member
9 years ago
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...
Need Help
  • Back2Basics's avatar
    Back2Basics
    9 years ago

    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

turbea's avatar
turbea
New Member
9 years ago

Unfortunately I got 6.78 as result instead of 6.44.

Back2Basics's avatar
Back2Basics
Resolver I
9 years ago

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

  • turbea's avatar
    turbea
    New Member
    9 years ago

    Yes, you are right. I dont need the extra .[Date] thing.

     

    Many thanks!