4 Replies Latest reply on Nov 28, 2010 12:03 PM by juancardona

    Using 'and' operator with date ranges

    TommyFisher

      Title

      Using 'and' operator with date ranges

      Post

      I want to set a field that shows whether a subscription is currently paused or not. However, when I try to use the 'and' operator with the 'greater than or equals to' operator, Filemaker will not allow me to use it. See below for the formula I am trying to enter. Am I going about this the right way to find whether today's date falls between the values in two date fields? Many thanks in advance Tommy ------- If ( Get(CurrentDate)  ≥ pauseStartDate  and  ≤ pauseEndDate; "Pause" ; "Not Paused" )