Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Dates in crm RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    CRM2016I have a form with a field formatted to date only. when importing a record for instance the record has a date field set to 15/04/2016 .. and the crm form displays that same date, however looking at the record in sql its shows that field as 14/04/2016 23:00:00  which is causing problems. Does anyone know why this is happening and what can be done to rectify it

    Dont ask me .. i dont know

    Wednesday, April 13, 2016 2:33 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    What sort of problems do the sql data give you?

    Regards

    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Thursday, April 14, 2016 6:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    It would be easy to identify the issue and suggest the solution if you can tell us the “Bahavior” set for the Date Field which is causing an issue.

    It seems to be that Behavior for this field is set as “User Local” which stores the Date Time value at the backend in UTC time zone format. So in CRM, on the Form the date is displayed correctly as per the user’s time zone but in the SQL it is stored as in UTC time zone format so it is showing it to date time value converted to the UTC format i.e. “14/04/2016 23:00:00”.

    For more information about the Date Time Behavior of the Date field please find the link http://inogic.com/blog/2015/06/handling-datetime-fields-in-microsoft-dynamics-crm-update-1/

    HTH

    Sam


    <p style="color:8DBBF7"><font face="Calibri" size="2"><b>Dynamics CRM MVP </b>| <a href="http://www.inogic.com" target="_blank"> Inogic</a> | <a href="http://inogic.com/blog" target="_blank">http://inogic.com/blog</a>| <a href="mailto:news@inogic.com">news at inogic dot com</a> </font></p> <p><font face="Calibri" size="2"><i>If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful" </i></font></p>

    Thursday, April 14, 2016 7:50 AM