DSXchange

How do i convert date 2010-May-12 to 12-05-10?

I am using Parallel extender.

Any suggesion pls?

StringToDate() followed by DateToString() using an appropriate format mask in both cases. Don't have access to my reference materials but off the top of my pointy little head, %yyyy-%mmm-%dd and %yy-%mm-%dd respectively?

chulett wrote:StringToDate() followed by DateToString() using an appropriate format mask in both cases. Don't have access to my reference materials but off the top of my pointy little head, %yyyy-%mmm-%dd and %yy-%mm-%dd respectively?

criag,

we can do the same using oconv and iconv functions too rite??

As OP is using enterprise edition, iconv and oconv is not recomended (however can be used in a basic transformer). Craig has suggested the appropriate solution.