DSXchange

Hi,

I would like to sort the data on a Date column where the date format is 'YYYY-MM-DD'. I would like to convert the date format to MM-DD-YYYY.

Could any one help in this regard.

Thanks

First sort your input date and then use DateToString() followed by StringToDate()

Hi Anbu,

I converted the input date using string to date and date to string but i didnt get the desired output.

Thanks,
Naveen

Hi,

I tired using the conversion of date field to month from date concatenated with the year from date and 01 for the day.

Then use string to date but didnt get the desired output.

Thanks,
Naveen

Can you post your input and output?

Hi,

Input---------------Output

2010/02/01--------02/01/2010
2010/03/01--------03/01/2010

Thanks,
Naveen

Are you not getting your desired output?

Hi Anbu,

When i use String to Date and Date to string its giving the same output as the previous format.

Thanks,

Naveen

try using the two functions seperately in two transformers....

one for date to string and other for string to date