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..
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..