date_from_ustring

cherry · Post by **cherry** » Wed Jan 20, 2010 4:05 am

Hi All,

Could some one help me how to get rid of this warning message.

My input is a reading from a sequential file and loading to a DB2 table.

Input has a field with type of Varchar(8) and Target field type of Date(10).

When I do a StringToData(<FieldName>,"%YYYY-%MM-%DD") iam getting the following warning message.

Transformer_2,0: Conversion error calling conversion routine date_from_ustring data may have been lost.

Thanks in advance

Best regards
Cherry

ray.wurlod · Post by **ray.wurlod** » Wed Jan 20, 2010 5:20 am

Is there a UStringToDate() function? If so, use it. Otherwise use a message handler to demote the warning to informational.

abhijain · Post by **abhijain** » Wed Jan 20, 2010 8:03 am

There is no UstringToDate function actually, you can first convert Ustring to string and then can use String to date function. like..

UStringToString(StringToDate(%datestring%,"%yyyy-%mm-%dd"))

chulett · Post by **chulett** » Wed Jan 20, 2010 8:11 am

StringToDate(<FieldName>,"%YYYY-%MM-%DD") says what your source data looks like, not the target. And that's 10 characters, hence the error using that with your 8 character source.

vvsmk · Post by **vvsmk** » Wed Oct 13, 2010 11:27 am

If IsValid('Date', DSLink58.open_dt)=1Then StringToDate(UStringToString(DSLink58.open_dt[1,10]),"%yyyy-%mm-%dd") Else "0000-00-00"

this one worked for me