Edate function

  • Thread starter Thread starter nadine
  • Start date Start date
N

nadine

Hi Guys,

Within excel there is a function edate which takes a start date and you can
add a number to it and it returns the final date. Is there something Similar
in Access as I am trying to work it into a query , but I can't see it in the
list.

Thanks Nadine
 
The DateAdd( ) function will do this, for straight addition:

For example DateAdd("d", 10, #1/1/09#)
will return #1/11/09#

If you want to add a certain number of Workdays, or weekdays you will need
to create your own function. There are a couple that are readily available.
Check out this one: http://www.mvps.org/access/datetime/date0012.htm
 
Back
Top