Hey there...

Im pretty new to using the SQL Server Reporting services. Im using it in SQL Express for the first time. And i have been playing around with it.

However as always with Microsoft there are date issues.

Ideally i would like all my date formats to be of "DD/MM/YYYY" since my location is ireland. Now i have been using the FormatDateTime(SomeExpression, 2) to obtain the date parts for various items in my reports. For Example, when giving a default to a parameter box this will show a date in the correct way 09/05/2005.

My main issue is when i do a query, i need to change the parameter to be of US dateformat ("MM/DD/YYYY") or else internation ("YYYY/MM/DD") in order for my query to work.

What is the best way to get around this?

Its very frustrating