Calculation based on date

[mvwhite]

I am not sure how to do the following and appreciate any help offered.

I need to have create an expression that gives me a total based on the number of days (different arrival and departure dates) where each day has a different value but remains the same from record to record. Perhaps this is a very easy thing to do, but I am just missing it.

Thank you

 

[MStCyr]

Check out the DateDiff function

 

[mvwhite]

Thank you for your reply, I will give it a try!