Number of days between two dates

[Bjarne_Allerup]

Hi I do not understand why this will not work. I try to calculate number of dates between ArriveDate and DepartureDate

It looks like [Departure Date]-[Arrive Date] give me number of Hours, which I try to divide by 24 to get number of days.

But it says “Invalid operator”???

Thanks in advance
Bjarne Allerup

[Koichi_Tsuji]

Try

Totalhours([Departure Date]-[Arrive Date])/24

[Bjarne_Allerup]

Now I get this

[Koichi_Tsuji]

You are missing /

[Bjarne_Allerup]

I can see that the returned value say

[Koichi_Tsuji]

Change column type to decimal instead of duration.

[Bjarne_Allerup]

You are my Hero!

Than you very much.

Bjarne Allerup