Model Builder Level 1 7.2.2

When I upload the csv file to the SYS08 Employee Details module, I get errors for the Start Date and Leave date fields. I set those data types to "Date" within the module, but the csv pretty clearly contains simple numbers (ex: 20120601). The instructions further indicate that I should not manipulate the csv file so as not to disturb the leading zeros in the code column.

This is a relatively easy fix with some creative excel formulas, but if I'm not supposed to open the csv file I don't know how I would fix this.

Answers

  • Nevermind, I realize now that this question is pre-empted in the "Check Work" part, though that was a little frustrating as I spent 30 min trying to figure out the problem. And ultimately just manipulated the csv file instead.