CRM2013
I am having a strange problem with a date only field in a custom entity.
I have imported records to this entity and when viewing a record the date on the form is showing 16/07/2014 which is correct.
If i run a SQL select query on that record, the date is showing as 15/07/2014 23:00:00
I have tried creating a record manually within CRM and setting the date via the date picker to 16/07/2014 and again when querying the record under SQL i get 15/07/2014 23:00:00
I have read a few threads that mention regional setting, however in this test environment all user's are set to the same time zone
Both the Servers that have the CRM and SQL servers on are both set with the same time zone
The reason I need to query CRM from SQL is because we import hundreds of customer reports and part of the query to identify which report is for which customer is based on the date field
I can only assume that there is a setting somewhere in CRM that sets a default time zone. Can anyone shed any light on this ?
Dont ask me .. i dont know