Troubleshooting: Date Format Error in Data Upload
Excel stores dates as the number of days since 1/1/1900. You set the value to date format however Microsoft Excel reads it as text rather than a number. Peakon can't convert a text value into a date value.
To test whether Microsoft Excel stores a field as a date, convert it to General data type. If the Sample value in the preview window displays a date, then it's a text value, not a number value.
Use the Text to Columns function on Microsoft Excel.
- Select the affected column, except for the header. You can select the first date in the column, then click Ctrl + Shift + ↓ on your keyboard.
- Click the Data tab at the top of the Microsoft Excel file.
- Select the Text to Columns button, which will open the Text to Columns wizard.
- On page 1 or 3 of the wizard, select the Delimited option and click Next.
- Leave page 2 of 3 as it is, with the Tab option selected, and click Next.
- On page 3 of 3, select the Date option, then select the current format of the dates. Example: if your dates are DD-MM-YYYY, select DMY.
- Click Finish.