How to Resolve Date Format Mismatch in SQL Server

Issue

An error occurs when using filters with DateTime data due to a date format or culture mismatch between the system and SQL Server.

Solution

1. Verify that the system date settings and settings in SQL Server are the same.

2. Check the date format in SQL Server using the following command:

DBCC useroptions;

3. If the date format in SQL Server is dmy, change it to mdy using the command:

SET DATEFORMAT mdy;

4. If the format existing is mdy, change it to dmy and check the dashboard.

References

• DBCC USEROPTIONS (Transact-SQL)
• SET DATEFORMAT (Transact-SQL)