Difference between revisions of "BetweenDates"

From Keyfax Wiki
Jump to: navigation, search
(Example Three)
(Example Three)
Line 53: Line 53:
  
 
'''Today'''
 
'''Today'''
25-04-2019
+
'''25-04-2019'''
  
The 24-04-2019 is between 23-04-2019 and (Today)25-04-2019 so the value returns as true.
+
The '''24-04-2019''' is between '''23-04-2019''' and '''(Today)25-04-2019''' so the value returns as true.
  
 
[[File:betweendatesfunction5.png]]
 
[[File:betweendatesfunction5.png]]

Revision as of 08:53, 25 April 2019

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

Date01 Betweendatesfunction11.png

Date02 Betweendatesfunction12.png

Today 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

Example Four

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

Setup