BetweenDates

Check if a date is between two other dates.

Example One

Check if one fixed date is between another fixed date and today with a result of true.

Setup

Example Two

Check if one fixed date is between another fixed date and today with a result of false.

Setup

Example Three

Check if one user entered date is between another user entered date and today.

Is Script.Date02 between Script.Date01 and today?

Setup

Demonstrations

True Result

Date01

Date02

Today for this example is 25-04-2019

The 24-04-2019 is between 23-04-2019 and (Today)25-04-2019 so the value returns as true.

False Result

Date01

Date02

Today 25-04-2019

The 22-04-2019 is not between 23-04-2019 and (Today)25-04-2019 so the value returns as false.

Example Four

Check if one user entered date is between a second user entered date and a third user entered date.

Check if one user entered date is between another user entered date and today.

Is Script.Date02 between Script.Date01 and Script.Date03?

Setup

Demonstrations

True Result

Date01

Date02

Date03

The 24-04-2019 is between 23-04-2019 and 25-04-2019 so the value returns as true.

False Result

Date01

Date02

Date03

The 22-04-2019 is not between 23-04-2019 and 25-04-2019 so the value returns as false.