5 Replies Latest reply on Feb 9, 2009 7:19 PM by krempch

    DATE function - 2009 dates not populating



      DATE function - 2009 dates not populating


      I have 4 Calc fields that compute dates 6mo, 12mo, 24 mo, 36 mo. out from
      the date entered in another field called "completed" (that field is Indexed DATE, 4-digit year).


      The problem: records where the manually entered initial value of "completed"
      is something in 2009, the 4 calc fields do not do the computation. (or there's an error and they don't display any dialog?).


      If the initial date in "completed" was something 12/31/2008 or earlier, I can
      manipulate the 4 calcs successfully. This is even true if I enter a date in 2009
      there (as long as the 2009 was NOT the initial value).


      Not sure what the issue might be. I am using FileMaker Pro 8 and 9 clients.

      The database is on a FileMaker 9 box.