MSSQL German Date Format -> Sugar English Date Format

[Sugarstefan]

Dear Forum,

I have a problem with date format:

I ll get the follwoing error message in the Logfile:
"SQL Server error: Arithmetischer Überlauf."

When this statement runs:

SELECT meetings.* from meetings_users,meetings WHERE (meetings.date_start >= '2011-07-31 22:00:00' AND meetings.date_start < '2011-08-31 22:00:00' AND meetings_users.accept_status != 'decline') AND meetings_users.meeting_id=meetings.id AND meetings_users.user_id='1' AND meetings.deleted=0 AND meetings_users.deleted=0

My SQL Server expected German Date format: 31.08.2011 for example. If I change the statement in the Console it works fine. IF i set "set language english" bevor running the statement than runs it also fine. Can anybody help me ..? I

many thanks

stefan

[rafael.q.g@hotmail.com]

I think sugar application is send the dates to database server always in formart yyyy-mm-dd. on sugar you can chnage how dates are displayed on front-end but not internally, how it is sent to your database.

I can suggest to you to adjust your database server to handle dates with format yyyy-mm-dd. On MySQL it is the dafault format, but on SQL Server I do not know how to adjust it.