It's the same in Queries as it is in VBA:
DateAdd(interval, number, date)
Where interval is a string expression that is the interval of time you want
to add (yyyy for Year, q for Quarter, m for Month and so on), number is a
numeric expression that is the number of intervals you want to add (which
can be positive to get dates in the future or negative to get dates in the
past), and date is the date to which the interval is added.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Odie" <oh******@sbcglobal.net> wrote in message
news:N4*****************@newssvr11.news.prodigy.co m...
The date add feature is accessed through Queries and build.