- Dates Stored with incorrect Date&Time
- Posted by vagg on April 18th, 2005
When inserted/updated a date field in the contact form the date displayed
(correct) is different from the date stored in the database (that is
incorrect).
Example:
BirthDate (default crm field) : value introduced in the form: 18/04/2005
BirthDate (default crm field) : value stored in the contactbase table:
17/04/2005 23:00:00
We have MS CRM installed in a SBS2003 Server.
All clents Clients and the SBS2003 Server have the Date&Time = (GMT)
Greenwich Mean Time (Lisbon, London,...)
Could anyone help me?
Thank you!!
vagg
- Posted by Matt Parks on April 18th, 2005
All datetime values are stored in GMT, so there will always be an offset between
what is entered/displayed and what is stored. This way, the times are displayed
properly for users across timezones/
Matt Parks
MVP - Microsoft CRM
----------------------------------------
----------------------------------------
On Mon, 18 Apr 2005 06:41:04 -0700, "vagg" <vagg@discussions.microsoft.com>
wrote:
When inserted/updated a date field in the contact form the date displayed
(correct) is different from the date stored in the database (that is
incorrect).
Example:
BirthDate (default crm field) : value introduced in the form: 18/04/2005
BirthDate (default crm field) : value stored in the contactbase table:
17/04/2005 23:00:00
We have MS CRM installed in a SBS2003 Server.
All clents Clients and the SBS2003 Server have the Date&Time = (GMT)
Greenwich Mean Time (Lisbon, London,...)
Could anyone help me?
Thank you!!
vagg
- Posted by Nathan Warner on April 20th, 2005
Just in case you weren't sure on how to change the date settings, the easiest
way is to click on the home page and click on the users name at the top left
of screen and adjust via date time settings.
"Matt Parks" wrote:
