Decrementing Date

[chad101]

I apologize for asking this question. I have searched all over these forums and on Google. I’m looking for a function that decrements the current date (by day only) based on a single integer value.

For instance, today is 8/28/06. A user enters 5. The return is 8/23/06.

I’ve looked into DateDiff() and tinkered with some other code snippets but I’m having no luck.

 

[Bodisathva]

DateAdd Function

from the Access Help File:

Returns a Variant (Date) containing a date to which a specified time interval has been added.

Syntax

DateAdd(interval, number, date)​

 

[RV]

Date() + Me.Interval, whereas Interval is the name of the control on your form where the user enters the interval.

RV