Calculating date ranges

[Adam]

I have a database with the following:

Start Date
End Date
Cancel Date

I need to know the number of days between the Cancel Date
and End Date. That number then needs to be used for
calculating a dollar amount.

I have no idea how to do this. Help!

Thanks,
Adam

 

[Howard Brody]

Try subtracting the dates in a query:

Field: DaysTilTerm: [EndDate]-[CancelDate]

Hope this helps!

Howard Brody

 

[Hugh O'Neill]

I have a database with the following:

Start Date
End Date
Cancel Date

I need to know the number of days between the Cancel Date
and End Date. That number then needs to be used for
calculating a dollar amount.

I have no idea how to do this. Help!

Thanks,
Adam

DateDiff() is a function you should look at for this. Then, if you
need the result in days, use the Format() function to show the result
in days.

hth

Hugh