ODBC Driver showing GMT date/time .

  • KM511140
  • 27-Oct-2008
  • 30-May-2011

Summary

SCR40062 fixes a known issue where any SC date/time field show up as gmt in Crystal. The scr has been verified as fixed in ODBC 6.2.6. However, the odbc only reports correctly in 6.2.x servers, but not when you use the SM7 legacy port. When binding to the SM7 Legacy port via Crystal, times still shows up in GMT. A new SCR has been opened to address this: QCCR1E31575

Question

When using the 6.2.6 odbc driver to run reports in Crystal against ServiceManger 7.X, all date/time values are presented in GMT.

Steps to replicate:

1. Using Crystal 9 or 11, Create a report against probsummary with open.time and Incident Number

2. Run the Crystal report, note the time is in GMT for the open.time field.

Note: Operator record is set for correct time zone.

Answer

QCCR1E31575