Date Range Inclusion

[Khanson82]

I have a hire date in this format (mm/dd/yyyy)..the report will run the 1st day of every month and I want to capture all records that are within the same month, 1 year ago for th whole month...

For example, if it 07/01/2010, I want the report to capture all records with a hire date of 07/01/2009-7/31/2009...

What is the easiest way to get this with a formula?? Thanks again..

 

[briangriffin]

Include this in your selection formula:


year(hiredate) = year(currentdate) - 1

and

month(hiredate) = month(currentdate)

 

[Khanson82]

Beautiful! It worked! Thanks again..