Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
while importing the data in the onpremise crm we are getting one hour difference how to resolve that issue RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    while importing the data in the onpremise crm we are getting one hour difference how to resolve that issue
    Friday, October 31, 2014 6:22 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    That is window application tool
    • Marked as answer by shiva_prasad Monday, November 10, 2014 6:27 AM
    Monday, November 3, 2014 4:47 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello Shiva,

    You need to make sure you have correct timezone setting before importing data to CRM, you can access timezone setting under personal option (Click on user icon in right corner and select options). What datatime you see in CRM UI is dependent on the timezone select for that user.

    HTH

    Microsoft Dynamics CRM Training|Our Blog | Follow US | Our Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Saturday, November 1, 2014 3:24 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Mahender Pal,

    Yes I set the same time zone in CRM and In my system also. but still it is taking few hours difference after importing the data. 


    Saturday, November 1, 2014 3:35 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    And my seniors telling like it is because of day light saving is this the correct reason.
    Saturday, November 1, 2014 3:38 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Sorry for the mistake which i made while typing your name
    Saturday, November 1, 2014 3:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It may be the reason, there are different consideration regarding date and time, please check this and this it will help you to understand how datetime is handled in MS CRM.

    HTH

    Microsoft Dynamics CRM Training|Our Blog | Follow US | Our Facebook Page | Microsoft Dynamics CRM 2011 Application Design
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    Saturday, November 1, 2014 8:08 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    How are you importing the data ? For example, through the CRM UI, or via API calls, or one of the third party tools like SSIS extensions or Scribe ? And in what format do you specify the DateTime fields ?

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Saturday, November 1, 2014 6:21 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Davidjennaway,

    I am importing through the tool which we prepare and date and time format is dd/mm/yyyy HH:mm:ss

    Monday, November 3, 2014 4:42 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That is window application tool
    • Marked as answer by shiva_prasad Monday, November 10, 2014 6:27 AM
    Monday, November 3, 2014 4:47 AM