Date variance - 7.3

Data privacy
Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Data privacy components
Data Quality and Preparation > Third-party systems > Data Quality components > Data privacy components
Design and Development > Third-party systems > Data Quality components > Data privacy components
Last publication date
2024-04-03

This function varies the input date by the number of days specified as an extra parameter.

If the input date is null, then the function returns the current date.

Option Description
Extra parameter This function requires an extra parameter.

The extra parameter must be a number of days.

If the extra parameter is 0 or null or if it is not a number, then the parameter is replaced with 31.

For example, if the input date is 05-11-2016, then the generated date is randomly selected between 04-10-2016 (31 days before the input date) and 06-12-2016 (31 days after the input date).

In the first example, the extra parameter is "0". Then, the function replaces this value with 31. The generated date, 07-07-2018, is randomly selected between 01-06-2018 (31 days before the input date) and 02-08-2018 (31 days after the input date).

In the first example, the extra parameter is "4". The generated date, 01-07-2018, is randomly selected between 29-06-2018 (4 days before the input date) and 06-08-2018 (4 days after the input date).

Input value Extra parameter Example of a masked value
02-07-2018 "0" 07-07-2018
02-07-2018 "4" 01-07-2018