|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2005, 09:06 PM
|
|||
|
|||
Calculating Months
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.  -- Message posted via http://www.accessmonster.com 
|
|
#2
May 13th, 2005, 10:13 PM
|
|||
|
|||
|
No older than 15 months prior to today? The criteria would be =
DateAdd("m", -15, Date()) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Kath via AccessMonster.com" wrote in message news:bd6f3180bb214cdc8d30aa6732191c9c@AccessMonste r.com... 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. -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Fiscal Year Calculations | Loretta | Worksheet Functions | 5 | August 19th, 2004 09:05 PM |
| Calculating absence periods in a rolling 12 months in excel | Mark | General Discussion | 3 | June 16th, 2004 07:58 PM |
| calculating years and months between 2 dates | Frank Kabel | Worksheet Functions | 1 | April 15th, 2004 11:01 PM |
Linear Mode
