Handling Fiscal dates as YTD, QTD, MTD with Report date dynamically

Hi Folks,

I have very nice challenge with me and my logic is working perfectly fine with 'Report Date' parameter to get the data using YTD, QTD and MTD but not working with Fiscal Date calendar.

Any idea how to achieve this.

My fiscal calendar starts from May 1st every year.

Case [date selection]

when "YTD" then [date]>=datetrunc('year', [report date]) and [date]<=[report date]

when "MTD" then [date]>=datetrunc('month',[report date]) and [date]<=[report date]

when "QTD" then [date]>=datetrunc('quarter',[report date]) and [date]<=[report date]

end

But when I select YTD my report should show from May 1st, 2019.

I have changed the date properties also but it is not working.

Any help is appreciated

Regards,