Date standardization functions

Date functions standardize date strings.

The strings can be dates, incomplete or approximate dates, and ages.

AGE
This function standardizes ages.
CDATE
The CDATE standardization function is part of the algorithm solution that is used to compare incomplete, partially valid or approximate date, or partially valid and approximate date ranges. The solution includes the CDATE standardization, bucketing, generation, and comparison functions.
DATE1
This function formats alphanumeric date data.
DATE2 (standardization function)
Using the DATE2 standardization function along with the DATE2 comparison function enables comparison of incomplete or partially valid dates.
GRDATE
This function formats the date in the same way as DATE1, but eliminates dates where the year is less than 1890 or greater than 2020.

Parent topic: Standardization functions

Last updated: 29 September 2023