How can I restrict calendar variable >= than a selected date in an expression?

GrizzlyBestia — Fri, 15 Oct 2021 08:46:52 GMT

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

topic How can I restrict calendar variable >= than a selected date in an expression? in App Development