Checking date format

More
7 years 2 months ago #15530 by Axel
Checking date format was created by Axel
Hello

The date format in source is, 2-Jun-03.
I want to verify if in target the same format of date is stored.
If any date format like 2-06-03 comes it should give an error and the particular record should go to error table.

Thank you,
Axel

Please Log in or Create an account to join the conversation.

More
7 years 2 months ago #15532 by admin
Replied by admin on topic Checking date format
Hi Axel

You can use "Is Date" validation function for this kind of transformation.




Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.