AnsweredAssumed Answered

How to set date field format when converting tables?

Question asked by sfraccascia on Oct 11, 2018
Latest reply on Oct 17, 2018 by sfraccascia

Hi there!

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!