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.