Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Data Quality: Rule to find Date difference

Free download

Posted by: Informatica Data Quality Unit

Download Data Quality rules that help you to compare dates and produces the result in difference with respect to Days, Months, Years and Hours.


Informatica provides the Core accelerator with the Content installer. The Core accelerator contains data quality rules that you can use with data from multiple regions. Core Accelerators provide solutions to common data quality issues in a country, region, or industry. Core Accelerators contain rules, reference tables, demonstration mappings, and demonstration data objects.


Compare date is a rule which is part of the Data Quality core accelerators available with Informatica Data Quality product. In this example, we are Comparing dates and producing the result in difference with respect to Days, Months, Years and Hours. To achieve this we are making use of following rules comes with the installation of Core Accelerators.



Name of RulesDescription

Compares two dates and calculates the difference between them. This mapplet provides information about the total time difference using the following units of measure:

- Hours

- Days

- Months

- Years


Each output value is exclusive from the other values. The outputs cannot be added to represent the difference between the data values.


  • Informatica Data Quality 9.5.1
Comments Comments (0)