Hi,
My date is in varchar 8 format like 20010431
when i do conversion its coming as 4444-01-01 any idea what can be wrong
Note: some dates are coming good but above conversion have issue
EMP_START_DT_ORIGINAL:20010431
IF IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd")
THEN StringToDate(to_transf.EMP_START_DT_ORIGINAL,"%yyyy%mm%dd")
ELSE StringToDate("44440101","%yyyy%mm%dd")
EMP_START_DT_after_ORIGINAL:4444-01-01
date format issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 87
- Joined: Mon Feb 18, 2008 3:58 pm
- Location: Sacramento, CA
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd")=1
Put this in transformer constraint to output link and draw another link as reject from transformer and make constraint condition as "Otherwise".
If your input records are not in valid date format it will go to reject link.
Put this in transformer constraint to output link and draw another link as reject from transformer and make constraint condition as "Otherwise".
If your input records are not in valid date format it will go to reject link.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/