Date Conversions

[iamnagus]

i want to convert date format dd/mm/yyyy to mm/dd/yyyy how to doit?

I have date column dd/mm/yyyy

i am trying to extract it using Sequential file stage with date format then it is not able to view data when i click viewdata option

then i am trying to using datatype of varchar then it is displaying data hen i click viewdata option,

after i send this data into transformer stage then the data is in varchar format
then i tried to convert using StringToDate function it is not properly working:
it is displaying in yyyy/mm/dd(as in default format in defined in administrator)

Can any one help me?

[ArndW]

Isn't this the same topic as this thread to which you didn't respond?