BetweenDates

From Keyfax Wiki
Revision as of 09:16, 25 April 2019 by Wikiadmin (talk | contribs) (Example Four)
Jump to: navigation, search

Check if a date is between two other dates.

Betweendatesfunction1.png

Example One

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

Setup

Betweendatesfunction2.png

Betweendatesfunction3.png

Betweendatesfunction4.png

Betweendatesfunction5.png

Example Two

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

Setup

Betweendatesfunction6.png

Betweendatesfunction7.png

Betweendatesfunction4.png

Betweendatesfunction8.png

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

Betweendatesfunction9.png

Betweendatesfunction10.png

Demonstrations

True Result

Date01 Betweendatesfunction11.png

Date02 Betweendatesfunction12.png

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.

Betweendatesfunction5.png

False Result

Date01 Betweendatesfunction13.png

Date02 Betweendatesfunction14.png

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.

Betweendatesfunction8.png

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

Betweendatesfunction9.png

Betweendatesfunction10.png

Demonstrations

True Result

Date01 Betweendatesfunction11.png

Date02 Betweendatesfunction12.png

Date03 Betweendatesfunction12.png

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

Betweendatesfunction5.png

False Result

Date01 Betweendatesfunction13.png

Date02 Betweendatesfunction14.png

Date03 Betweendatesfunction12.png

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

Betweendatesfunction8.png