g1smd - 11:57 pm on Dec 4, 2011 (gmt 0)

You'll need YYYY-MM-DD format.

If your text editor has RegEx edit capability then you could easily reformat the data.

Replace * with whatever is immediately before and after the date: comma, quote, space, whatever.

First pass: *([0-9][0-9])/([0-9][0-9])/([0-9][0-9][0-9][0-9])* => *\3-\1-\2*

Second pass: *([0-9])/([0-9][0-9])/([0-9][0-9][0-9][0-9])* => *\3-0\1-\2*

[edited by: g1smd at 12:03 am (utc) on Dec 5, 2011]