AddDate() doesn't seems to be working with new Version. We have tried it through Portal only.

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After installing the latest TDM version 4.10, we executed a masking job for a small set of tables. The ADDDAYS() doesn't seems to be working. 

SOURCE DB: ORACLE

Environment

Release : 4.10

Component : Web Portal - Data Masking

Cause

The issue is with the year. The algorithm doesn't recognize year 1 (0001) as a valid year.

 

According to Oracle's documentation:

 

Valid DATE Values
A valid DATE value must fall between January 1, 1000, and December 31, 9999. It must conform to one of three styles: numeric, packed numeric, or month name. You can mix these styles throughout a session

 

https://docs.oracle.com/cd/B19306_01/olap.102/b14346/dml_datatypes005.htm

Resolution

Below is a quick test with 2 rows of data:

2000-01-01 (01-JAN-00)
0001-01-03 (03-JAN-01)

When using the ADDDAYS masking function to add 10 days to the two dates, we see 10 days were added as expected to the first row, which is a valid date. However, nothing was added to the second date.

Try changing the date to a valid date, such as 2000-01-01, and you should find the masking work.