|
Home > Archive > MS Access data conversion > April 2005 > Date functions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Roffee 2005-04-26, 8:25 pm |
| 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 2005-04-26, 8:25 pm |
| 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).
"Roffee" <noname@nowhere.com> wrote in message
news:426e9518$2@news
.broadpark.no...
> 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
>
>
|
|
|
|
|