2 Replies Latest reply on Jul 14, 2013 3:25 PM by danlee

    New to filemaker.  Need help with calculation

    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!