Subtracting Dates in Access

[Jnarwed]

Please help,

I would like to subtract two dates and have the total number of days returned. For example

[Date Started] - [Current Date] = x (number of days)

I haven't seen a function for this. Please let me know if it's possible.


Thanks,

Jnar

 

[downwitchyobadself]

Look in the Access help index for the functions DateDiff and DateAdd. They're fairly straightforward. You can also just subtract them and get a number.

 

[downwitchyobadself]

Sorry, forgot to say that the Date() function returns today's date, and the Now() function returns today's date with this second's time.