Need help in subtraction two date fields

[ashmitp869]

Hi there,

I have two date fields like below date format. I want to get the Date diffrence in hh:mm.

I have used this :

interval([Client Departure DateTime]-[Client Arrival DateTime], 'hh:mm')

But not getting results. Please kindly assist.

[Lisa_P]

Your dates don't seem to be detected as dates when loaded, they are loaded as strings, based on the left alignment of the field in the chart. So subtraction is not an option for text strings. You need to apply date# function to the date in the load script.