DVF date functions
Learn about the date functions used in a data validation.
Use date functions in Data Validation Functions to validate attributes that have a date format of YYYY-MM-DD.
| Function | Description | Sample |
|---|---|---|
range | The validation function checks that the attribute value is between the two static dates. If the validation is met, then the appropriate validation message is displayed. |
|
equals | The validation function checks that the attribute value matches the given static date or another date attribute value exactly. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator. |
|
gt | The validation function checks that the attribute value is greater than the given static date or another date attribute value. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator. |
|
gte | The validation function checks that the attribute value is greater than or equal to the given static date or another date attribute value. If the validation is met then the appropriate validation message is displayed. This function supports the NOT conditional operator. |
|
lt | The validation function checks that the attribute value is lesser than the given static date or another date attribute value. If the validation is met then the appropriate validation message is displayed. This function supports the NOT conditional operator. |
|
lte | The validation function checks that the attribute value is lesser than or equal to the given static date or another date attribute value. If the validation is met, then the appropriate validation message is displayed. This function supports the NOT conditional operator. |
|
exists | The validation function checks that the given attribute value exists. If the validation is met, then the appropriate validation message is displayed. |
|
missing | The validation function checks that the given attribute value is missing. If the validation is met, then the appropriate validation message is displayed. |
|
relative date comparisions | The validation function checks that the attribute value is within a relative date, in days, to the current date. For example, check if the DOB value is less than 1 day from the current date when validated. During validation, the current date is compared against relative dates in the Coordinated Universal Time (UTC) timezone. See the section below for more details. Note: For DVFs created with the Validate event field set to Create & Update profile or Update profile we recommend you only use the
gte function. For DVFs created with the Validate event field set to Create profile, we recommend you only use the |
|
Relative dates comparison to UTC timezone
The date and timestamp fields are compared against relative dates in the Coordinated Universal Time (UTC) timezone.
When entering a date, there may be an anomaly when it compares the user's date (who is in a different timezone) to the UTC timezone. Here's an example.
Timezone A is 8 hours ahead the UTC timezone. A user in timezone A enters the current date as the 30th September at 4am. However, as per UTC, the current date is 29th of September at 8pm. During validation, the system infers the current date as 29th (as per the UTC timezone) and throws an error.
Timestamps, however, do not have such anomalies since the Timestamp field type is stored and compared in UTC only. System dates for entities, such as Start Date and End Date, are stored as timestamps and hence, will not face such anomalies.