View Full Version : date 30 months prior


shutls
04-18-2002, 07:58 AM
How do i calculate a date in a query that is 30 months prior to a date given.

I tried this but it gave me results all with next year's date!
Start Renewal Date: DateDiff("m",-30,[Expiration Date])

Any suggestions would be greatly appreciated!

David R
04-18-2002, 08:05 AM
Your syntax is correct, however you need DateAdd, not DateDiff.