Date formatting can be set in Docboss in three places:

• On specific projects, under Project > Set Up > Main
• On Project Templates, under Project Settings > Date Format
• Under Admin, for the whole system

To see the current date settings for the whole system in DocBoss or change the date format setting go to Settings > under Admin click on General.

Here you can see the current date format settings. If you'd like to change this, click on the edit icon and select the format from the drop down menu.

Alternatively, if you have a Customer that wants the date displayed differently than others, you can change the settings in the project. Starting in your project, go to Main

Scroll down to Settings and select the format by clicking on the drop down menu. Once you've made the changes be sure to Save Project.

To update Excel's regional formatting - On your PC type "Set Regional format" in your search bar.

Set your Country or region (1) and select Change Date Format (2)

Note: If using MM/DD/YYYY or M/D/YY set your country to United States.

Select the drop down for "Short Date" and choose the date format that matches your date setting in DocBoss

You may need to close and re-open excel for the changes to take effect.

Date errors while uploading CSV files

If you are getting date format errors when uploading CSV files into DocBoss it is likely caused by Excel's regional settings. When Excel opens on your PC it displays date formats according to your regional settings. See our article here for more information.