How to convert multiple date formats into single date format in single column

[#1]

Hi Everyone,

I have to do like, in single column there dates in multiple format, so how i can do or achive easily.

1) suppose dates are like "mm/dd/yyyy" and "dd/mm/yyyy" .

2) "mm/dd/yyyy" is in date format and "dd/mm/yyyy" in text .

but values are there in template.

Regards,

Kumar.

[#2]

hi,

you can bring data into a single format while loading.... (using date function)

date(DATEFILDNAME,'DD/MM/YYYY') as DATE

Regards

[#3]

Hi,

Thanks,

I Got the solution!...

Regards,

Kumar.

[#4]

can u post the solution for dis