RS.exe and date-type parameter.

Hi All,

I have a report with 4 parameters, 2 of them are date-type parameter. I intend to run this report via RS.exe by passing different parameters for different scenario. The issue that I have at the moment is passing date-type parameter via the VB Script file.

In my report I use "dd-mm-yy" format. I tried many ways to assign date value to my parameters, but I am always getting the following error:

"Unhandled exception: Default value or value provided for the report parameter 'myParam' is not a valid value".

Syntax that I use:

myParam = "01-01-1900"

myParam = DateTime.Parse("01-01-1900")

myParam = DateTime.Parse("#01-01-1900#")

All of them didn't work.

My question: how to assign date value to the parameter?

Many Thanks,

Man

Can you post your script?|||

Hi,

Thanks for your reply. However I solved the issue by changing the date format to US format (mm/dd/yy).

Cheers,

XL