Please be gentle as I'm new to this Access lark!!
Cheers.
: Please be gentle as I'm new to this Access lark!!
: Cheers.
Use the DateAdd() function. DateAdd has the following parameters: Interval - yyyy, m, d Number - number of intervals to add Date - date to which the interval is added
If you wanted to add 3 months to May 5, 1999,you would use the following:
DateAdd("m", 3, #5/4/99#)
Good Luck.
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
: Please be gentle as I'm new to this Access lark!!
: Cheers.
Use the DateAdd() function.
DateAdd has the following parameters:
Interval - yyyy, m, d
Number - number of intervals to add
Date - date to which the interval is added
If you wanted to add 3 months to May 5, 1999,
you would use the following:
DateAdd("m", 3, #5/4/99#)
Good Luck.