Calculating dates into number of days

[HeatherG]

Hi everyone

I am a newbie to FileMaker, so please be patient with me if I am not clear in the way I am explaining what I am trying to do.

I am attempting to create a database that will accept accommodation bookings and want to have a field that will calculate the number of days that will or have elapsed between dates, for example. Field Name = ArrivalDate (Displays 3/05/2004) Field Name = CheckOutDate (Displays 13/05/2004) Field Name = TotalNights (Displays whatever the calculated number is).

I imagine that this a fairly easy thing to do, or has already been done before, but I just don't know how to get my head around it.

Thanks

HeatherG

[Echo33029]

Try TotalNights = CheckoutDate - ArrivalDate. This will give you the total number of days between the two dates.

[HeatherG]

Thanks Echo

Works perfectly.

HeatherG