How to assign date value

[mary2003]

Hi,
I like to assign a date value to one parameter. It's not assigning properly.

Here is the scenario.


I will be getting values of parameters from a URL.

http://<server-name>/crystal/enterp...1&Rec_Date=Date(2003,05,05)&Department=001047

In the above URl application is able to assign department, but not Rec_date. It's bringing up the report with the default value.
I hardcoded the date value in certain format. It didn't workout.

Following the code which sets values for parameters.

Set reportParameters = queryResult.Item(1).PluginInterface(&quot;Report&quot.ReportParameters
Set Fields = CreateObject(&quot;CrystalReports.Fields&quot

For Each Parameter in reportParameters
Set myParameter = CreateObject(&quot;CrystalReports.ParameterField&quot
Set Value = CreateObject(&quot;CrystalReports.ParameterFieldDiscreteValue&quot
if ((UCase(Parameter.ParameterName) = &quot;START_DATE&quot) then
Value.Value = Request.QueryString(&quot;Start_Date&quot
'Value.Value = &quot;Start_Date;date(2003,05,01);true&quot;
end if
Next
' Code for displaying report.


Can you please help me in assigning date.

Thanks in advance.

Mary

 

[Turkbear]

Hi,
Is it just a typo? you refer to Rec_Date in the url
but test for START_DATE...

 

[mary2003]

Sorry, it's Start_Date not Rec_Date.