Issues with Date formats

[hari4dsx]

Hello,

I have been trying to convert a date present in a flat file in yyyy-mm-dd format to mm-dd-yyyy format and store it in a database.

I have used a modify stage to convert the given date to string in mm-dd-yyyy format using String_Date_Function.

Now, before loading it into database as the string has to be converted into Date format,I tried to implement this using another modify stage and using function Date_from_string.

But the second Modify stage is giving an error and the job is being aborted.

Can anyone suggest a solution to this problem.

Or,else xan anyone suggest a different way out.

Thanks in advance.

[ray.wurlod]

Welcome aboard. Two adjacent Modify stages are not supported (this is in the documentation). Put a Copy stage between them.

[hari4dsx]

Thanks a lot Mr. Wurlod.
Placing a copy stage in between the modify stage solves the problem.

Regards