Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM Date time Issue RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have a CRM application.  We have a date field that gets filled in by our users.  Inside CRM things appear to be Ok.  But when I look into database it appears 4 hours ahead of what was saved and displayed in CRM application.

    i.e. if I save "07/08/2010 11:42:00 AM" it shows "07/08/2010 03:42:00 PM" in database but it appears correct in CRM.

    can someone please explain what is wrong with my settings?

    Thursday, July 8, 2010 4:57 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, Santy.

     

    This difference appears because DateTime in CRM data base is stored in UTC format.

    Truth is opened the prepared mind

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, July 8, 2010 6:22 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    MayankP indirectly points out the difference between referencing "createdon" in a FilteredAccount View, and referencing "createdon" from the AccountBase table.  The view automatically converts the value of the datetime attribute to the executing user's registered timezone, and establishes an unperturbed extra attribute with "utc" appended to the original attribute's schema name.
    Dave Berry
    Thursday, July 8, 2010 7:51 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi, Santy.

     

    This difference appears because DateTime in CRM data base is stored in UTC format.

    Truth is opened the prepared mind

    My blog (english)
    Мой блог (русскоязычный)
    Thursday, July 8, 2010 6:22 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Yes, Andriy is correct..you will get the correct data in utc field.

    for e.g. 

    select createdon,createdonutc  from FilteredAccount

     

    Thursday, July 8, 2010 7:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    MayankP indirectly points out the difference between referencing "createdon" in a FilteredAccount View, and referencing "createdon" from the AccountBase table.  The view automatically converts the value of the datetime attribute to the executing user's registered timezone, and establishes an unperturbed extra attribute with "utc" appended to the original attribute's schema name.
    Dave Berry
    Thursday, July 8, 2010 7:51 PM
    Moderator