Hi,
I'm importing data from Excel where the date format is : [space]01Aug 12
I'm really struggling to transfer this into a standard date format (ideally yyyy.mm.dd). all the SQL functions I've tried don't work, I'd like to avoid having to reformat it in Excel (I need to keep the file size...