Result for month (s) ago

Use Dateadd

Adds or subtracts a time interval to a date and gives you back the new date.

Function Name: DateAdd
Syntax:DateAdd(interval, number, date)

interval - can have these values:
d day
h hour
m month
n minute
q quarter
s second
w weekday
ww week of year
y day of year
yyyy year

number is a positive number of time you want to add to the date if number is negative then that number will be subtracted from the date

Example: DateAdd("m", 3, "1-MAY-98")
This example will add 3 months to May 1st 1998

found info at http://www.loudasp.com/KnowledgeBase/showfaq.asp?faqid=784&a mp;catID=28