New to filemaker and coming from access. Need help with formula...

[danlee2672]

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!

[LaRetta]

Month ( Summary Report Date ) = Month ( Get ( CurrentDate ) )

 

If you use this calculation in script then it would simply be:

 

If [ the above calc ]

... do something because it is true

Else

... do something else because it is false

End If

 

If you create a calculation with it then the calculation must be checked 'do not store calculation results' in the calc dialog storage options (bottom right in the calc dialog).  Let us know if you get stuck or if I'm misunderstanding your need.

 

And welcome to FM Forums!!!