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