Date Range of Last Year Last Full Month 1

[crystaledout]

Hi, I essentially need to put into my select criteria that I want all records that were opened during the previous month of last year, e.g., today is September 1, 2010; I would like all records opened during the month of August 2009.

Thanks for any guidance you can provide!

 

[briangriffin]

What if you run it during January 2011? Do you want Dec. 2010 or Dec. 2009?

 

[crystaledout]

Thanks for your help. I would want it to be December 2009.

 

[briangriffin]

Try these:

Start of range:

dateadd("d",1,dateadd("m",-1,dateadd("yyyy",-1,maximum(lastfullmonth))))

End of range:

dateadd("yyyy",-1,maximum(lastfullmonth))

 

[crystaledout]

Wow, that's amazing! Thanks so much!