Identify Invalid Dates

sb2212 · Post by **sb2212** » Mon Jan 30, 2017 10:37 am

Hi,

We have a situation.

The source is a comma separated text file with data as below:

Country,dDate,ENm
US,2016-06-22,Smith
UK,2015-03-03,John
US,2016-15-10,Rose

We are trying to read the data using a sequential file. Tried 2 approaches:
Read everything as varchar and then used IsValidDate along with String to Date conversion. This gave warnings "String to Date Conversion".

Read the date field as Date and added a reject file to the sequential file. It rejected the data but gave a warning "field has import error and no default value".

The requirement is to reject the records with bad date and pass on only the clean data without warning.

Is there a way to achieve this?

Thanks.

chulett · Post by **chulett** » Mon Jan 30, 2017 11:38 am

Don't use "IsValidDate" to check the string, use "IsValid" with a data type of "Date" instead.

sb2212 · Post by **sb2212** » Tue Jan 31, 2017 12:31 am

Thanks Chulett. It worked. Marking this as closed.