I've got a isue with dates. I've got a source database which is set up with US date format but everything else is UK date format If I just use date pickers it's working fine but I want to use a stored procedure which returns the first date of the month and a display field. I can select something from the drop down menu but when I press view report it just goes back to the select a value on the parameter. I've tried setting the dateformat in the sproc but without joy.

Hi AndyRL, Based on your description, I am still confused about the scenario. Is there a Date/Time parameter, when you select a date by using the date picker, the date value need to be passed to a stored procedure? If so, do you mean the date format cannot be identified by the stored procedure? If I have misunderstood, could you please post an example to elaborate the issue, then I will try to assist you to find the root cause. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.