Calculating date ranges

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
Try subtracting the dates in a query:

Field: DaysTilTerm: [EndDate]-[CancelDate]

Hope this helps!

Howard Brody
 
Adam said:
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
Click to expand...


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
 
Back
Top