Troubleshooting date import issues

Troubleshooting date import issues

If the commission status date is not imported correctly, it maybe the current date format is not being recognized. For this, the date format needs to be set.
STEPS TO TROUBLESHOOT DATE IMPORT ISSUES.
  1. Go to your excel file, and select your column.
     
  2. Go to 'Data' > 'Text to Columns'.  
  3. Select 'Delimited' and click on 'Next'.
     
  4. Deselect all checkboxes and click on 'Next'.
     
  5. Select 'Date' and its format.
      
      
     
  6. Click on 'Finish'. 
     
  7. Now, on your excel file, select your date column and right click on it. 
     
  8. Select 'Format Cells'.
      
      
     
  9. Select the date and its type.
      
     
     
  10. Click on 'Ok'.