I need a flag in my master calendar that flags all dates in the last 6 months from the last full month.
Example today is March 8, 2017. So the last full month is February 2017. I would want this flag to flag all dates in the months
September 2016-February 2017
If the todays date is April 1st I would want the flag to be from
October 2016-March 2017.
Here is my calendar script:
MinMax: LOAD Min([ReportingDate]) asMinDate, //max([ReportingDate]) as MaxDate // use the reporting date as a reference for the month to display as prior today() asMaxDate//use today's date as a reference for the month to display as prior Resident Fact;