Time difference between CRM and Report RRS feed

  • Question

  • Hi,

    When running report with datetime fields, we have a time difference of 9 hours.
    All user settings are on +1 GMT
    In crm database datetime are stored as UTC
    Regional settings of CRM Server and SQL reporting server are Dutch +1 GMT

    CRM 4.0

    Please advice

    Thursday, February 26, 2009 8:17 PM


  • Are you having problems with 'canned' or default reports in CRM or just custom reports?  If custom reports, be sure to run your queries against filtered views.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Monday, July 20, 2009 7:33 PM
    Thursday, February 26, 2009 8:31 PM