Hi ,
I am getting Following warning while converting data in string format to date
Transformer :Conversion error calling conversion routine date_from_string data may be lost
The String Length is 8(e.g. 20341221),and I used the StingToDate function and got the output 2034-12-21 but with warnings...
What should be the appropiate Date datatype Length and how i can suppress above warning??
Dates aren't "in" any particular kind of format. It's only when they are converted to string that format becomes important. Having created a date, as in this thread, you can then apply a DateToString() function and specify an explicit date picture such as "%dd-%mm-%yyyy".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
i have same problem when we upgrade to version 7.5.2 , it was not a problem in 7.5.1. check some records may not be convertible to date.
you can try this:
if DDate<19000000 then '1900-01-01' else StringToDate(InputLink.Column, "%yyyy%mm%dd")