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 &quot;Mark As Answer&quot; on the post
and &quot;Mark as Helpful&quot; </i></font></p>