Hi, I'm not sure I get what are you trying to do - an example would help since I suppose I have done something similar already. About the original question: why are you performing a cast of the same column in 2 different formats? Or I'm getting it wrong? I did quite a bit of work with dates, cast of dates in different…

Ajith, could you please elaborate a bit on what are trying to do? Do you want to know how to filter the report through a dashboard prompt showing the previous year data? Why the "is between" than? Is only to specify Month or day+month and the year is always the previous year? A couple of details or a screenshot would help…