I have created an external content type which connects to a SQL database view so that it is read only. It is an employee table that contains fullname hiredate and birthdate columns. From this content type I have also created the external
list and added it to the HR site on SharePoint Server 2010.
When I connect to the view in SQL, and execute the table, it shows the proper dates. When I view the list on SharePoint it shows the dates off by one day for both the hire date and birth date columns.
I have deleted and recreated the content type using SharePoint Designer 2010 and no change.
Any ideas what is happening?
View Complete Post