https://community.qlik.com/t5/QlikView/if-statement-with-last-month/m-p/1777532#M717382 <P>Hi, I have a field called AMS_DATE, I want to create a field inside of my script that returns a value of '1' if AMS_DATE occurred last month.&nbsp; Please help!</P> Tue, 26 Jan 2021 19:35:54 GMT drohm002 2021-01-26T19:35:54Z https://community.qlik.com/t5/QlikView/if-statement-with-last-month/m-p/1777532#M717382 <P>Hi, I have a field called AMS_DATE, I want to create a field inside of my script that returns a value of '1' if AMS_DATE occurred last month.&nbsp; Please help!</P> Tue, 26 Jan 2021 19:35:54 GMT https://community.qlik.com/t5/QlikView/if-statement-with-last-month/m-p/1777532#M717382 drohm002 2021-01-26T19:35:54Z https://community.qlik.com/t5/QlikView/if-statement-with-last-month/m-p/1777555#M717383 <P>in your load statement add this (make sure AMSDATE is a date</P><P>load ...<BR />if(monthstart(AMS_DATE) = addmonths(monthstart(today()),-1),1)&nbsp; as YOURFLAG,<BR />...<BR /><BR /></P> Tue, 26 Jan 2021 22:01:38 GMT https://community.qlik.com/t5/QlikView/if-statement-with-last-month/m-p/1777555#M717383 edwin 2021-01-26T22:01:38Z