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
Try
Totalhours([Departure Date]-[Arrive Date])/24
Now I get this
You are missing /
I can see that the returned value say
Change column type to decimal instead of duration.
You are my Hero!
Than you very much.
Bjarne Allerup
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |