New to filemaker. Need help with calculation
I have just started using filemaker and was wondering how I can get this formula, in access, run in filemaker
SRQuota: IIf([Summary Report Date]>DateSerial(Year(Date()),Month(Date()),1),1,0)
So if a date falls within within the current month under Summary Report Date then SRQuota would equal 1.
Today's Date 7/4/2013
Summary Report Date 7/1/2013
SRQuota = 1