Edate function

[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

 

[Dale Fye]

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