Convert DateTime Parameter to String

I have 2 reports and i have enabled Drilldown(Navigation) for the 1st Report.
One of the Parameter is DateTime which is passed to the 2 reports which should
treat this parameter as string since it's defined as string. How will i
convert the
DateTime to string Parameter for the Drilldown report. I tried all these
scenarios
for Parameter expressions and it doesn't work.
Convert.ToString(Parameters!Parameter2.value)
Convert.ToDateTime(Parameters!Parameter2.value).ToShortDateString()
FormatDateTime(Parameters!Parameter2.value,"mm/dd/yyyy")
Any help in this regard is appreciated? . I don't change the parameter for
second report to DateTime. Since it calls a WebService with parameters which
expects a string and not a System.DateTime.Try:
=Format(Parameters!Parameter2.value,"MM/dd/yyyy")
Note month is MM=month not mm=minutes.
HTH,
Magendo_man
"RAGHAVAN JAYARAMAN" wrote:
> I have 2 reports and i have enabled Drilldown(Navigation) for the 1st Report.
> One of the Parameter is DateTime which is passed to the 2 reports which should
> treat this parameter as string since it's defined as string. How will i
> convert the
> DateTime to string Parameter for the Drilldown report. I tried all these
> scenarios
> for Parameter expressions and it doesn't work.
> Convert.ToString(Parameters!Parameter2.value)
> Convert.ToDateTime(Parameters!Parameter2.value).ToShortDateString()
> FormatDateTime(Parameters!Parameter2.value,"mm/dd/yyyy")
> Any help in this regard is appreciated? . I don't change the parameter for
> second report to DateTime. Since it calls a WebService with parameters which
> expects a string and not a System.DateTime.
>|||Thanks for the reply. I tried it,it didn't work but somehow i got it working
with Cdate syntax
= CDate(Parameters!Parameter2.value).ToShortDateString();
"magendo_man" wrote:
> Try:
> =Format(Parameters!Parameter2.value,"MM/dd/yyyy")
> Note month is MM=month not mm=minutes.
> HTH,
> Magendo_man
>
> "RAGHAVAN JAYARAMAN" wrote:
> > I have 2 reports and i have enabled Drilldown(Navigation) for the 1st Report.
> > One of the Parameter is DateTime which is passed to the 2 reports which should
> > treat this parameter as string since it's defined as string. How will i
> > convert the
> > DateTime to string Parameter for the Drilldown report. I tried all these
> > scenarios
> > for Parameter expressions and it doesn't work.
> >
> > Convert.ToString(Parameters!Parameter2.value)
> > Convert.ToDateTime(Parameters!Parameter2.value).ToShortDateString()
> > FormatDateTime(Parameters!Parameter2.value,"mm/dd/yyyy")
> >
> > Any help in this regard is appreciated? . I don't change the parameter for
> > second report to DateTime. Since it calls a WebService with parameters which
> > expects a string and not a System.DateTime.
> >