locked
CRM displays different date than stored in DB RRS feed

  • Question

  • I have a date field in my custom entity. In the database, it displays May 1st, 2009. However, in CRM, it displays April 30th, 2009.

    Did I miss a configuration setting to display the correct date? For all my dates, it's displaying 1 day behind what is in the database.

    It might be worth while to note that the time attached to the date is 00:00:00:000

    Wednesday, July 29, 2009 8:34 PM

Answers

All replies

  • The time field will different base on your time zone settings.

    Jim
    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn
    Wednesday, July 29, 2009 8:41 PM
    Moderator
  • Do i really have to change the time zone on the workstation to display the correct date?

    Wednesday, July 29, 2009 8:57 PM
  • Yes, you need to setup your personal(Tools>Options) time zone.


    Jim Wang - MVP Dynamics CRM - http://jianwang.blogspot.com, http://mscrm.cn
    • Marked as answer by trallan Sunday, August 2, 2009 12:47 AM
    Wednesday, July 29, 2009 9:54 PM
    Moderator
  • LocalTimeFromUtcTimeRequest LocalTimeFromUtcTime Message (CrmService)

    Retrieves the local time for the specified Universal Time Coordinate (UTC) time.

    The relevant classes are specified in the following table

    more information you can found in sdk


    韓建興 http://jamson.cnblogs.com
    Thursday, July 30, 2009 2:36 AM
  • OR point your queries to the filtered views and they will take of it for you.

    Leon Tribe
    Want to hear me talk about all things CRM? Check out my blog
    http://leontribe.blogspot.com/
    or hear me tweet @leontribe

    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Saturday, August 1, 2009 10:59 PM
    Saturday, August 1, 2009 10:59 PM