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!
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!