Hi there,
I am trying to restrict a calendar date variable using set analysis but struggling to get any formulas to work with a date.
{<[Cal Date]={">=$(='$(vReportingDateMonthly)')<$(=Addmonths(date('$(vReportingDateMonthly)'),12))"}>}
This set analysis shows Cal Date >= 15/03/2021 < 15/03/2022. How can I apply this analysis to my calendar date variable?
WeekYear([$(vPrefix) W/C Date])&'-'&Num(Week([$(vPrefix) W/C Date]), '00') as [Supply BirthYear/Week]
This variable goes back to 2020 -WK47. I want it to match Cal Date >= 15/03/2021 < 15/03/2022