SSRS 2005 Date Picker Parm Problem
Posted on 2011-02-11
Using Date Picker in 2 of my report parms (From Date To Date).
It works fine in the USA as mm/dd/yyyy. User picks From and To dates, report runs and records appear. Great...
But now, when they do the same thing, but from a Canadian location (which has date form as dd/mm/yyyy, the Date Picker fails when they chose a date range of 22/12/2010 to 25/12/2011. You get back a error saying the value in box is in valid. It is looking at the date as mm/dd/yyyy when they execute report, and there is no month 22 or 25.
Do not understand why the Date Picker is confused. It presents the date as dd/mm/yyyy but then edits it against the format of mm/dd/yyyy and gets confused and errors out. FRUSTRATING..
Any easy way around or do I have to just make the 2 date fields as strings and tell user to key in date as mmddyy and not use the date picker option ?