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

Expression
Databox Value
Result
Comments

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:

Example of the BetweenDates expression

Last updated