Forum Discussion

ganeshnr073's avatar
ganeshnr073
Helper I
4 years ago
Solved

Get difference between date and time

I need to get the difference between two date and time coulmns, The output should be in hours . 

 

It needs to be merged column - Current Date.

 

Thank you ! 

 

  • ganeshnr073 , if they are columns then use datediff

     

    datediff([merged], now() , hour)

     

     

    or

     

    datediff([merged], [current_date] , hour)

2 Replies

  • ganeshnr073 , if they are columns then use datediff

     

    datediff([merged], now() , hour)

     

     

    or

     

    datediff([merged], [current_date] , hour)