Gary,
 
I studied the link you provided and otherwise looked into the issue.
 
Your statement “the date format is determined by the date format of the server” I think is technically incorrect.  SQL server doesn’t have a date format per se,as dates are not stored as strings on the database.  What SQL server does have is a “string to date” and “date to string” default conversion format. 
 
If an application is passing dates to SQL server as strings, it can cause problems on the SQL server side converting the strings to dates with different collations.  It is advised to not to pass dates in string format to SQL server for this reason.  If you send dates to SQL server using a date datatype, you are not going to have an issue with collation (because no string
to date data conversion takes place on the SQL server side).
 
You can read about the issue here and it explains how CB could be adjusted to not be dependent on SQL server collation:
 
stackoverflow.com/questions/27011693/whi...ault-datetime-format
 
If you must send dates to SQL server in string format,you could check the collation of the SQL server you are connected to, and the date format of the client, then format the dates in the correct format in the string you send to SQL server so the “string to date” conversion on the server side will work as expected.  In this way it would make the client date format and SQL server "string to date" format independent and the issue would be resolved.
 
David Nelson
Dynamic Enterprise Technologies Inc
Connected Business Channel Partner
Seattle | Portland | Los Angeles

Read More...