TYPECONVERSION

[ntr]

Hi,

My input data format is varchar:(08August2011)

i want to convert out put as date (2011-08-08)

i had written logic

String To Date((Left(col,2):-:(If ((col,3,3)="JAN" Then "01" Else if (col,3,3)="Feb" Then "02"........upto December i had written and :-:Right(col,4),"%dd-%mm-%yyyy")

its working fine .

is there any option to handle this insted of writing this much of big syntax

Thanks

[ArndW]

I'm not at a DataStage session where I can confirm, but think that

Code: Select all

StringToDate(In.Col,"%dd%mmmm%yyyy")

should work.

[BI-RMA]

Confirm that.

[ntr]

Sorry for the delay .

its working perfectly thank you so much ArndW