About nikita_gnilozub

Hello to everyone! I have run into the following problem In Activity #4 when importing Data into the "Rep Setup" module, the fields with Start Date and End Date are returning "Invalid Date" errors and it shows some errors as well. The original Date format in the 2015 Headcount details.csv is as follows : 3/10/10, 1/18/15 (so the US way) I remember from the Introduction course there was an option to choose the date formatting, however I suppose the CSV file should be organized in the inverse pivot positions (I did try to change the pivots in the module, but there are no options for the columns). One of the way is to fix the dates in source file, but once I open the csv in Excel the dates are mixed as well. This is still possible to accomplish, however I suppose there must be a better way. Please find the screenshots attached. As of now I am proceeding with the course and hope to fix the problem later (hoping the dates are not utterly needed in the closest chapters). Thank you in advance! ... View more