Hi,

New to CR am hoping you can help! I need to select data for two time periods. A start date and end date are being inputted via parameters.

Calc1:
The first date selection needs to be 28 days prior to the end date of the previous year.

Calc 2:
The second date selection needs to be a YTD calculate for the previous year (so 1/1/prev year to the end date of the previous year).

For example, if the user enters 6/10/2011 00:00:00 as the start date and 6/16/2011 00:00:00 as the end date, for calc 1 we need 28 days prior to and including 6/16/2010. For calc 2 we need YTD from 1/1/2010 thru 6/16/2010.

I'm guessing using DateAdd is the way to go but am having trouble with the syntax and am also not sure if the time becomes an issue when doing the comparisons.

Thanks so much in advance!

I think this partially gets me there...but I also need to subtract 1 from the year for the first calculation. So, I need to subtract 28 from the days and 1 from the year. Can you please confirm what that syntax would be?

Thanks!