I am trying to calculate previous year data for the same month range.
Current Year
Start Date: 04/01/08 ?StartDate
End Date: 04/30/08 ?EndDate
Previous Year
Start Date: 04/01/07
End Date: 04/30/07
Example:
Current Yr Previous Yr Variance
Books Sold $ 500.00 $ 400.00 $ 100.00
I have set up a parameter in my select statement for the current year start date and end date for the current year. See above, ?StartDate and ?EndDate.
The fields that i am trying to calc are in blue.
Thanking you in advance, Lisa