How to clean date format? (URGENT)

[#1]

Hi all,

I have an Excel datasource but in the Transaction Date column, it consists of various date format, for example:

7/12/2010

09-08-10

(Blank)

-

ANy idea how to clean this data?

THanks

[#2]

its the same =(

ive uploaded the source too

[#3 · Accepted solution]

Hi,

Please see the the attachment,i hope it will solve u r purpose

Thanks

vivek

[#4]

It works! Thanks a bunch!

Buy u coffee next time~

[its_anandrjs]

Hi,

No need to write subfield in place of this you can use replace command because if symbol change you need to write another code by this you can change

Date(Replace(TransactionDate,'-','/'), 'DD-MM-YYYY') as NewTransactionDate2

See the attched sample file solution sheet.

Rgds

Anand

[#6]

PERFECT!