Hi Lynn; thanks for your response. But i have got about 100 reports which use the dates.. these reports work for our US customers. It's not working for our Spanish Customers.

The difference is the SQL server 2005 Properties in the language it says Spanish instead of English US.. How can i change that back to English US.

Your Query does not give me error, but that would mean changing 100 reports..

Is there a way i can change the language toi English US.