I am converting some csv files to shapefiles as part of a model using the 'Table to Table' tool. So far so good, until I realized that the DATE field was not imported correctly: it is in the MM-dd-yyyy format in my input tables and it automatically return as dd-mmm-yyyy in the output tables, but any dd from 1 to 12 is interpreted as MM. For example, 08-06-2015 (meaning 06 August) becomes 08-Jun-2015. Is there a way to bypass the problem or convert the field (without messing up my column order)?
Thanks in advance for your help!