Restrict the month

[aghabdurauf]

Hi all,

I have 12 months Dates from 31-12-2020 to 30-11-2021

I use =monthName(addmonths(max(Date_Email), -1))

when I select 31-12-2020 it shows Nov-2020.

I want to restrict this however Nov 2020 is not in my data.

Thanks

[rubenmarin]

Hi @aghabdurauf, and why is the addmonths function with -1, you can add an If to check the date before creating it, but if you don't create the date the fist month of data won't be related to any date.