Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
in your load statement add this (make sure AMSDATE is a date
load ...
if(monthstart(AMS_DATE) = addmonths(monthstart(today()),-1),1) as YOURFLAG,
...