You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
I have a delimited file which contains dates of the format "dd/MM/yyyy".
When a date is missing/null, the file contains "00/00/0000" so I have used the replace component to change to "".
However, the compliance check rejects with "Date format not valid" - the fields are flagged as nullable with the "dd/MM/yyyy" date pattern.
I've seen other posts with a link to a bug regarding checking null before attempting to parse the date, but the bug is shown as fixed in v2.2.5 - I'm using TOS 2.3.0.
Any thoughts anyone?
Offline
Pages: 1