Date functions

[Roffee]

Hi.

I'm a bit confused about date functions in Access. I need the program to
calculate a new date that lays 15 days ahead of a given date in a table. I
studied the datediff function, but as I see it, it only returns a number of
days (or other time period) between two dates. I need a future date as
output.

Hints anyone?


-roffee

 

[Pat Hartman]

There are lots of date functions. They all do different things. Use the
DateAdd() function. It adds/subtracts days (or other units) to the
specified date).