> For the complete documentation index, see [llms.txt](https://docs.soraco.co/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.soraco.co/docs/faq/how-to-configure-the-qlm-management-console-date-format-to-match-your-sql-servers.md).

# How to configure the QLM Management Console Date format to match your SQL Server's

If your SQL Server uses a date format that does not match the default date format used by the QLM Management Console (yyyy-MM-dd HH:mm:ss), you must update the date format settings of the QLM Management Console to match your server's.

* Launch the QLM Management Console
* Go to the Manage Keys tab
* Click Sites and select your site
* Click Server Properties
* Locate the "regional" category
* Update the following properties to match your SQL Server's format:
  * sqlDateFieldFormat - Default Value: Format({0}, "YYYY-MM-DD")
  * sqlDateTimeFormat - Default Value: yyyy-MM-dd HH:mm:ss
  * sqlDateValueFormat - Default Value: yyyy-MM-dd