Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011: Date showing 1 days less after fetching the records RRS feed

 > 

  • General discussion

  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    When I fetch the record contains dates it is showing 1 day less.

    For eg: In CRM views date is showing 29-01-2014. But when I fetch the same record in plugin/workflow/custom application it is showing me 28-01-2014.

    Need help.

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Yogesh Vijay Mulay

    Wednesday, January 29, 2014 5:45 AM

All replies

  • Discussion
    Sign in to vote
    2
    Sign in to vote

    hi,

    please check issue is occurred because of UTC time difference because crm time and custom application time difference is 5:30 hours in india.


    Add 5:30 hours in date time fields.
    Wednesday, January 29, 2014 5:51 AM
  • Discussion
    Sign in to vote
    0
    Sign in to vote

    Correct.  Each user record contains reference to what time zone that the user is part of.  This is used to offset the UTC time on the record that CRM displays.  You will need to take this into account. 

    Also, certain activities like tasks where you do not have both data and time on the form so that the user can set the time, the default time of midnight UTC will be stored in the database.  So retrieving the date and time from records with only the date field on the form will likely show with the wrong date.

    Jason Peterson

    Wednesday, January 29, 2014 9:29 AM