If you are getting date format errors when uploading CSV or Excel files into DocBoss it is likely caused by Excel’s regional settings. Opening a CSV in excel automatically converts any dates using Excel’s expected format. If customers have a required format, and your Excel regional setting is different, Excel will apply its settings when you open the CSV file.
How can you fix date errors while uploading CSV files in DocBoss? You have several methods to choose from.
Option 1 is to change your Excel regional settings based on the project data settings. For detailed information on how to update your Excel regional settings, see our article here. In a default situation (no requirement from customer), you should have your export setting match your Excel regional settings so excel doesn’t misinterpret the dates.
Option 2 is to change the date format in your DocBoss Project to match your excel regional settings. See below for instructions on how to edit your date settings in your DocBoss project.
In the Main screen of your project, change the date format to match the Excel setting. Click to save project and re-upload your file.