Do you have the need to adjust date format on a project by project basis depending on the customer? DocBoss enables you to adjust the way you format the date on a system wide basis or for each project too.

Date formatting can be set in DocBoss under Admin for the whole system, or it can be done in each individual project, should your customers have different date format requirements.

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.