1 Reply Latest reply on Aug 26, 2010 11:17 AM by philmodjunk

    Annual statement

    michael_alexander@me.com

      Title

      Annual statement

      Post

      Hello, i want to make a annual statement.

      I must be a count like this:

      If (Startdate contract > 01-01-2010 ; Startdate contract; 01-01-2010)

      If ( IsEmpty (Stopdate contract) ; 31-12-2010; Stopdate contract)

      This doesn't work.

      Any idea? 

        • 1. Re: Annual statement
          philmodjunk

          01-01-2010 is interpreted by filemaker as 1 minus 1 minus 2010 = -2010

          Try using the Date function in your expressions:

          If ( Startdate contract > Date ( 1 ; 1 ; 2010 ) ; Startdate contract ; Date ( 1 ; 1 ; 2010 ) )

          Since 2010 is likely not the value you'll want next year, you may want to use Year ( Get ( CurrentDate ) ) in place of 2010 in these expressions.

          Note that calculations that refer to get ( CurrentDate ) will not update correctly unless you use storage options to specify that they be unstored.