3 Replies Latest reply on Mar 10, 2011 12:33 PM by philmodjunk

    Calculation --> If (Get (Current Date) is within 2 weeks of  DateField); result 1; result 2

    firth5

      Title

      Calculation --> If (Get (Current Date) is within 2 weeks of  DateField); result 1; result 2

      Post

      I need to write a calculation that does the following:

      If (Get (Current Date) is within 2 weeks of  DateField); result 1; result 2

      Where if the current date is within 2 weeks of the DateField, the result will = 1, otherwise it will be 0.

      --

      How do I express the "within 2 weeks of " specifically?

      I tried:

      If (Get (Current Date) < (DateField - 14)); 0; 1

      But it didn't work.  I don't think "14" is the way to express the two weeks in this case.  

      ---

      thanks!

      Eric V

      FMPAdv10 ; mac