Get difference between date and time

[ganeshnr073]

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 ! 

[amitchandak · Accepted solution]

@ganeshnr073 , if they are columns then use datediff

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

or

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

[ganeshnr073]

Thank you for the help !!