AnsweredAssumed Answered

Using 'and' operator with date ranges

Question asked by TommyFisher on Nov 27, 2010
Latest reply on Nov 28, 2010 by juancardona


Using 'and' operator with date ranges


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" )