In JTX 9.3, the list of found jobs is not what is expected when using advanced find or job queries to find jobs by date

Description

The list of jobs returned when finding jobs by date does not match the expected results. Instead, jobs are returned that match the date, with the day and month switched. For example, searching for jobs on June 5 returns jobs with the specified date set to May 6.

Cause

This is caused by a discrepancy between the databases locale setting and the client locale setting. These setting must match to ensure the correct jobs are returned.

Solution or Workaround