Hi

I'm looking for a calculation formula to give me a result in another field from an ''If function'' for BETWEEN two dates or timestamps?

This formula give me a correct result for after a date

C_BerthFree = If ( DateTimeOut ≤ LastModificationTime ; "Free" ; "" )

Can anyone help with this?

Thanks

Changed my mind.

If you want it to show "Empty" until the

arrivaltime (not the departure time), try this:1) Validate DateTimeOut to be greater than or equal to DateTimeIn.

2) Change your "Berth Full" calculation to this:

Case ( DateTimeIn >= C_GetCurrentTimestamp ; "Empty" ; not IsEmpty ( DateTimeIn ) and IsEmpty ( DateTimeOut ) ; "Full" ; DateTimeOut >= C_GetCurrentTimestamp ; "Full" ; "Empty" )

(As you can see, it's a bit more complicated.)

Revised version attached.

Mike