ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 238764


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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. 



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


Release : 4.10

Component : Web Portal - Data Masking


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.