AnsweredAssumed Answered

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

Question asked by firth5 on Mar 9, 2011
Latest reply on Mar 10, 2011 by philmodjunk

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

Outcomes