if statement with last month

[drohm002]

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.  Please help!

[edwin]

in your load statement add this (make sure AMSDATE is a date

load ...
if(monthstart(AMS_DATE) = addmonths(monthstart(today()),-1),1)  as YOURFLAG,
...