Difference between revisions of "BetweenDates"

From Keyfax Wiki
Jump to: navigation, search
(→‎Example Two)
(→‎Example Four)
 
(8 intermediate revisions by the same user not shown)
Line 4: Line 4:
 
[[File:betweendatesfunction1.png]]
 
[[File:betweendatesfunction1.png]]
  
−
===Example One===
+
==Example One==
  
 
Check if one fixed date is between another fixed date and today with a result of true.
 
Check if one fixed date is between another fixed date and today with a result of true.
Line 18: Line 18:
 
[[File:betweendatesfunction5.png]]
 
[[File:betweendatesfunction5.png]]
  
−
===Example Two===
+
==Example Two==
  
 
Check if one fixed date is between another fixed date and today with a result of false.
 
Check if one fixed date is between another fixed date and today with a result of false.
 +
 +
===Setup===
  
 
[[File:betweendatesfunction6.png]]
 
[[File:betweendatesfunction6.png]]
Line 30: Line 32:
 
[[File:betweendatesfunction8.png]]
 
[[File:betweendatesfunction8.png]]
  
−
===Example Three===
+
==Example Three==
  
 
Check if one user entered date is between another user entered date and today.
 
Check if one user entered date is between another user entered date and today.
  
−
===Example Four===
+
Is '''Script.Date02''' between '''Script.Date01''' and today?
 +
 
 +
===Setup===
 +
 
 +
[[File:betweendatesfunction9.png]]
 +
 
 +
[[File:betweendatesfunction10.png]]
 +
 
 +
===Demonstrations===
 +
 
 +
====True Result====
 +
 
 +
'''Date01'''
 +
[[File:betweendatesfunction11.png]]
 +
 
 +
'''Date02'''
 +
[[File: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.
 +
 
 +
[[File:betweendatesfunction5.png]]
 +
 
 +
====False Result====
 +
 
 +
'''Date01'''
 +
[[File:betweendatesfunction13.png]]
 +
 
 +
'''Date02'''
 +
[[File: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.
 +
 
 +
[[File: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 a second user entered date and a third user entered date.
 +
 +
Is '''Script.Date02''' between '''Script.Date01''' and '''Script.Date03'''?
 +
 +
===Setup===
 +
 +
[[File:betweendatesfunction15.png]]
 +
 +
[[File:betweendatesfunction16.png]]
 +
 +
===Demonstrations===
 +
 +
====True Result====
 +
 +
'''Date01'''
 +
[[File:betweendatesfunction11.png]]
 +
 +
'''Date02'''
 +
[[File:betweendatesfunction12.png]]
 +
 +
'''Date03'''
 +
[[File:betweendatesfunction17.png]]
 +
 +
The '''24-04-2019''' is between '''23-04-2019''' and '''25-04-2019''' so the value returns as true.
 +
 +
[[File:betweendatesfunction5.png]]
 +
 +
====False Result====
 +
 +
'''Date01'''
 +
[[File:betweendatesfunction13.png]]
 +
 +
'''Date02'''
 +
[[File:betweendatesfunction14.png]]
 +
 +
'''Date03'''
 +
[[File:betweendatesfunction17.png]]
 +
 +
The '''22-04-2019''' is not between '''23-04-2019''' and '''25-04-2019''' so the value returns as false.
 +
 +
[[File:betweendatesfunction8.png]]

Latest revision as of 09:22, 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

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.

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

Setup

Betweendatesfunction15.png

Betweendatesfunction16.png

Demonstrations

True Result

Date01 Betweendatesfunction11.png

Date02 Betweendatesfunction12.png

Date03 Betweendatesfunction17.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 Betweendatesfunction17.png

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

Betweendatesfunction8.png

Retrieved from ‘http://wiki.keyfax.biz/index.php?title=BetweenDates&oldid=1167’