Datepicker date invalid for type

Hi,
I'm working on a report within the development environment. A couple of the
parameters are Date/Time parameters for which RS provides a Date Picker.
The Date Picker returns dates consistent with my regional settings i.e. in
dd/mm/yyyy format, however, once I've selected a date from the date picker
with a day greater than 12, the message "An error occurred during local
report processing. The value provided for the report parameter "From_Date"
is not valid for its type." Which one would assume is because somewhere
within .NET or RS its expecting dates in mm/dd/yyyy format.
I can certainly type in a date in either mm/dd/yyyy, mmm/dd/yyyy,
dd/mmm/yyyy or even yyyy/mm/dd or yyyy/mmm/dd but once I move out of the date
parameter, RS reformats the date in dd/mm/yyyy format.
Of course we can surive without a date picker, but its a nice feature and a
shame not to use it. I will persevere without it for now and hope that
someone has a resolution to this problem.
How do I get the datepicker and .NET/RS to agree on which format the dates
are in?
thanks
MattI have RS2005. I found installing SP1 fixed the problems I was having
with this.
The correct behaviour is for the datepicker to display the date in the
format according to the browser regional settings.
Prior to SP1 I had to make my date parameters Strings or pick them from
a database list.
BlackDuck wrote:
> Hi,
> I'm working on a report within the development environment. A couple of the
> parameters are Date/Time parameters for which RS provides a Date Picker.
> The Date Picker returns dates consistent with my regional settings i.e. in
> dd/mm/yyyy format, however, once I've selected a date from the date picker
> with a day greater than 12, the message "An error occurred during local
> report processing. The value provided for the report parameter "From_Date"
> is not valid for its type." Which one would assume is because somewhere
> within .NET or RS its expecting dates in mm/dd/yyyy format.
> I can certainly type in a date in either mm/dd/yyyy, mmm/dd/yyyy,
> dd/mmm/yyyy or even yyyy/mm/dd or yyyy/mmm/dd but once I move out of the date
> parameter, RS reformats the date in dd/mm/yyyy format.
> Of course we can surive without a date picker, but its a nice feature and a
> shame not to use it. I will persevere without it for now and hope that
> someone has a resolution to this problem.
> How do I get the datepicker and .NET/RS to agree on which format the dates
> are in?
> thanks
> Matt