Microsoft KB Archive/861327

= When you insert or update an Activity record, the value in the CreatedOn date field in the ActivityBase table does not reflect the accurate time =

PSS ID Number: 861327

Article Last Modified on 12/1/2004

-

The information in this article applies to:


 * Microsoft CRM 1.0

-



TechKnowledge Content
'''SUMMARY

'''This article discusses when you insert or update an Activity record, the value in the CreatedOn date field in the ActivityBase table does not reflect the accurate time.

MORE INFORMATION

For example, if a record is added at 11:00 a.m. CST, the value in the CreatedOn date field displays 5:00 p.m.

Microsoft CRM stores dates in UTC, which is Universal Coordinated Time. UTC is based largely on GMT, but they are not the same thing. In particular, UTC does not recognize daylight savings time. Therefore, when other time zones move between Daylight and Standard time, UTC time remains fixed.

The values in the CreatedOn date column of the ActivityBase table are approximately 6 hours after the time that the Activity was actually created or updated. This functionality is working as designed in Microsoft CRM version 1.0.

This article was TechKnowledge Document ID: 32687

Keywords: kbMBSMigrate KB861327

Technology: kbBizSolSearch kbCRM kbCRM100 kbCRMSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.