Future Date Check 📅 (Dynamic)

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Summary

This package contains 2x rules: “Is a future date” and “Not a future date” (compared to current date at time of execution) which can help assessing whether certain date values are fit for purpose:

Is A Future Date? [Category: Validation]

image.png

Checks that the input date is a date in the future (relative to the date at time of execution). For assessing values such as ‘close date’ (on open contracts).



See below for preview of the function definition logic and some sample output results:

image.png


Is Not A Future Date? [Category: Validation]

image.png

Checks that the input date is not a date in the future (dynamic). For assessing values such as ‘date of birth’ 'account open date' 'last updated date' etc.



See below for preview of the function definition logic and some sample output results:

image.png


Compatibility:

These functions are compatible with all instances of Data Studio from v2.1.11 onwards.

[dl-button|Download|https://us.v-cdn.net/6031645/uploads/COJ80GGC0WPN/future-date-check.dmx]

Tagged:

Comments

Categories