BetweenDates
Determine if a date is between two dates.
Will compare inclusive of the dates used (ignoring time). This can be arranged in any order e.g. BetweenDates(Today, "15-10-2010") or replace Today with a date e.g. BetweenDates("15-10-2010","23-10-2010").
BetweenDates ("15-10-2030",Today)
15-10-2027 08:00pm
True
Will compare inclusive of the dates used (ignoring time)
BetweenDates (Today, "15-10-2030")
15-10-2027 08:00pm
True
Arguments can be arranged in any order
BetweenDates(“15-10-2030”,”23-10-2010”)
15-10-2019 08:00pm
False
Or supply two dates
Example
The Expressions above could be used to check whether the date entered by the operator, or the date picked up by the system is before, after or within a time-frame. For example, to check the date of a claim against an insurance policy or warranty, or whether the enquiry is before or after a change in company Policy, to ensure the appropriate action. The example below shows an Expression being tested and returning True or False if an entered date is within range:
Last updated