Future Date Check 📅 (Dynamic)

AdrianW

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]

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:

Is Not A Future Date? [Category: Validation]

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:

Compatibility:

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