Upload tool date format error
I'm using the upload tool to automatically insert data into some tables. One of the datasets includes a monthly report with a date like "July 2011" and the column has "MMMM yyyy" as the date format. But when I upload the data, the date column always comes across as blank. If I set the column's datatype to plain text, the data gets inserted/uploaded as expected. Is there a way to have the column be a date, but accept dates in the "July 2011" format?