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
|
|||
|
|||
help needed with date expression
What expression in a query would gather the data from the current date, going
back 13 months to the beginning of that month? For instance: If I run the query now, I'd like it to query all data greater than June 1, 2007. or... If I run the query this September, it would query all data greater than August 1, 2007. Thanks for any help!! -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
help needed with date expression
Try:
= DateAdd("m", -13, Date() - Day(Date()) + 1) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Slez via AccessMonster.com" u23064@uwe wrote in message news:873c317359d79@uwe... What expression in a query would gather the data from the current date, going back 13 months to the beginning of that month? For instance: If I run the query now, I'd like it to query all data greater than June 1, 2007. or... If I run the query this September, it would query all data greater than August 1, 2007. |
Thread Tools | |
Display Modes | |
|
|