Hi Sanker, the formula you write does work for the original data you put, but does not apply when I switch to 2023 - 01 data. The logic I want to apply here is
1) if dateformat is the same as effective date format less than one month then yes - but this equal clause doesn't seem to work.
2) if dateformat is earlier than effective date format less than one month then no,
for example, 11-2022 should be the recognised as "No" if the effective date is 2023-01, and 12-2022 should be recognised as "Yes". Can you take a look if there is anything wrong with my formula?