Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM DB showing wrong date, Application showing correct date RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear All,

    We are using Dynamics CRM 4.0. We have Date on the Screen is showing is different than the CRM DB. For example Date is showing on the Screen as 28-Oct-2010. But in DB storing as 27-Oct-2010. We are facing lot of problems becoz of this since this date is critical. Anybody got the same problem ? Kindly provide the solution if anybody solved..

    Thanks in Advance,

    NAG.

    • Edited by crmpnk1 Thursday, October 28, 2010 5:50 AM s
    Thursday, October 28, 2010 5:47 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    CRM database stores the datetime in UTC format. Does not matter what the crm and server setting are. What time zone are you using?

    for e.g if you are in sydney, add 10 hours or 9 hours based on the day light saving to crm db datetime, you will get correct datetime value.

     

    I hope it helps.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney, Australia http://mscrmshop.blogspot.com
    • Proposed as answer by Amreek Singh Tuesday, November 2, 2010 3:17 AM
    • Marked as answer by Donna EdwardsMVP Friday, November 12, 2010 8:07 PM
    Tuesday, November 2, 2010 3:17 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Check:

    • Server Date/Time
    • Timezone settings - CRM stores dates/times in UTC

    Each user can control their own Timezone settings in:

    • Tools Menu
    • Options...
    • General Tab
    • About half way down, select applicable Time Zone
    --pogo (pat)
    Thursday, October 28, 2010 6:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Checked Both Application & DB Servers Timezone. Both are unique. Also in CRM Application Time zone is same. But still it's same problem.

    Any reason ?

    Thursday, October 28, 2010 8:56 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Where in the DB are you looking for your date? If you are looking in the base tables, then it may well come up with the wrong date because the UTC settings will not have been applied. You must use the Filtered<entityname> views to get the correct dates.
    Ian Carter UNIT4 CRM R&D Manager
    Monday, November 1, 2010 1:08 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    CRM database stores the datetime in UTC format. Does not matter what the crm and server setting are. What time zone are you using?

    for e.g if you are in sydney, add 10 hours or 9 hours based on the day light saving to crm db datetime, you will get correct datetime value.

     

    I hope it helps.

    Amreek singh Senior CRM Consultant CDC Praxa Sydney, Australia http://mscrmshop.blogspot.com
    • Proposed as answer by Amreek Singh Tuesday, November 2, 2010 3:17 AM
    • Marked as answer by Donna EdwardsMVP Friday, November 12, 2010 8:07 PM
    Tuesday, November 2, 2010 3:17 AM