AnsweredAssumed Answered

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

Question asked by cookachoo on Jul 6, 2010
Latest reply on Jul 6, 2010 by philmodjunk

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

Outcomes