AnsweredAssumed Answered

New to filemaker.  Need help with calculation

Question asked by danlee on Jul 5, 2013
Latest reply on Jul 14, 2013 by danlee

Title

New to filemaker.  Need help with calculation

Post

     Hi,

      

     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

      

     then

      

     SRQuota = 1

      

     Thank you!

Outcomes