1 Reply Latest reply on Jul 6, 2010 12:53 PM by philmodjunk

    Novice user FMP 11 Advanced I have the following fields - Visit 1 date, Visit 2 date. Visit...

    cookachoo

      Post

      Novice user

      FMP 11 Advanced

      I have the following fields - Visit 1 date, Visit 2 date.

      Visit 2 date should occur between 42 and 49 days post Visit 1 and so i have the fields 'Win V2 start (Visit 1 date +42)'  and 'Win V2 end (visit 1 date +49)'.

      I want to be alerted when visit 2's happen outside the 42-49 days.

      I have made an additional field (V2 in window) that  I thought I could insert a calculation into that would could say Yes if the Visit 2 date is within the window and No if the date falls on either side of 42-49 days.

      please help