Reg:date Conversition

[ntr]

HI,

I an having source file date column as 8/14/1999.
Expected output is 08-14-1999.

I am using.
sequentialfile---->Trans----->sequential file.

I am using string todate(column,'%mm-%dd-%yyyy)
I changed the project defaults as same.

But the output i am geeting is 1999-14-08.

Can any aone help on this?

Thanks

[SURA]

You can use DateToString(StringToDate( ColName,"%m/%dd/%yyyy"),"%mm-%dd-%yyyy").

Or

check for IsValid and if condition passed then just use convert / ereplace

DS User

[pandeesh]

Code: Select all

if IsValid('date',input_column) then Convert('/','-',input_column)