Problem: 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


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.


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

Either the database locale setting or client locale setting must be changed so that they match.