Forum Discussion

martinmdj's avatar
martinmdj
New Member
8 years ago
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...
  • martinmdj's avatar
    martinmdj
    8 years ago

    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. 

martinmdj's avatar
martinmdj
New Member
8 years ago

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. 

  • layokenny's avatar
    layokenny
    Frequent Visitor
    8 years ago

    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?

  • layokenny's avatar
    layokenny
    Frequent Visitor
    8 years ago

    Hi there, 

     

    Can you please expand on this two processes that you mentioned 

    1) How did you subtract two date/time values ? did you use "DATEDIFF"?

    2) How did you change the result data type to Decimal Number ? 

     

    Thanks