Last Month Flag for the current year

[drohm002]

Hello, i have built a LastMonthFlag and it correctly grabs April, but i only want it to grab April of the current year.  How do i achieve this? It is currently grabbing April for every year in my dataset. My code is below.

IF(Month(datefield) = Month(now())-1,1,0) as LastMonthFlag

Please help me achieve this, thank you!

[anat]

Can you try using monthname function

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

[Lech_Miszkiewicz · Accepted solution]

IF(MontStart(datefield) = MonthStart(now(),-1),1,0) as LastMonthFlag

cheers