Error while converting date format

[kumar3846]

Hi all,


I am getting error while converting date formats

here in my job iam converting date to string format and

again iam doing string to date conversion here is my logic

DateToString(a,"%yyyy-%mm-%dd")= b
If IsNull(b) Then SetNull() Else StringToDate(((b)[6, 2]:(b)[9,2]:(b)[1,4]),'%mm-%dd-%yyyy')


while doing this process iam getting warning :

APT_CombinedOperatorController,1: Conversion error calling conversion routine date_from_string data may have been lost

and in the target dataset its showing data as *******

pls help me out this



Thank you very much

[ray.wurlod]

Edit your post - check "Disable Smilies in this post" so that we can see the actual expression.

[thumsup9]

Kumar,

Your smileys hide the key information..

[kumar3846]

thank you for ur response i have disables the smileys thank you

[kumar_s]

Try this

Code: Select all

StringToDate(((b)[6, 2]:(b)[9,2]:(b)[1,4]),'%mm%dd%yyyy')