I need some help adding a new parameter that will accept a date Range of current, 3 months, and 6 months. I have a current data set and I am using a embedded data source. Within the Date Range parameter the returned report must start at the 1st of the month and end today. Will I need to add the parameter to the Query or just a reference to the new parameter?
=DATEADD(mm, -3, DATEADD(mm, DATEDIFF(mm, 0, Today()),0)) as FirstdayofThreeMonthDateRange
Is there a better way of doing this? and has anyone had to deal with fiscal year parameters?