dynamic last 12 months column

Hi selpaqm 

Try this:
Var _EndMonth = EOMONTH(Today()) --return date in datetime format of the last day of the month based on today date

Var _LastY = Date(Year(_EndMonth)-1,month(_EndMonth),day(_EndMonth)) --Last year date

this_year=if(date(date)>=_LastY&&date(date)<=_EndMonth, "TY","")

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Hi selpaqm 

You can use EOMONTH(TODAY(),-13) to replace the static date, i.e. 

this_year=if(date(date)>EOMONTH(TODAY(),-13), "TY","")

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.