Calculating Months

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kath - 13 May 2005 21:06 GMT

I am working on exporting information from another system. One of the
queries I need to write includes data from 15 months prior to present date.
How do I write this in SQL to only include information no older than 15
months?

Any help would be greatly appreciated. :)

Reply to this Message

Douglas J. Steele - 13 May 2005 22:13 GMT

No older than 15 months prior to today? The criteria would be >=
DateAdd("m", -15, Date())

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I am working on exporting information from another system. One of the
> queries I need to write includes data from 15 months prior to present
[quoted text clipped - 3 lines]
>
> Any help would be greatly appreciated. :)

Reply to this Message