The Random Date masking format generates random dates within a date range to replace the original column values.
- Start Date: The lower bound of the range within which random dates should be generated
- End Date: The upper bound of the range within which random dates should be generated
The inputs should be in format
YYYY-MM-DD. Start Date should be less than or equal to End Date.
Supported Data Types
- Combinable: Yes
- Deterministic: No
- Reversible: No
- Uniqueness: Yes. The total number of distinct values in the specified range must be greater than or equal to the number of values in the column.
To generate random dates between January 1, 2016 and December 31, 2019 for the column
BIRTH_DATE, you can use the Random Date masking format with the dates entered as the two parameters.
The following table shows the original
BIRTH_DATE column and the