AnsweredAssumed Answered

Using 'and' operator with date ranges

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

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

Outcomes