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
Comments
0 comments
Please sign in to leave a comment.