Formatting Parameter and Field Dates

I'm new to Reporting Services so bear w/ me,

I'm having troubles with formatting the parameter and field dates. To resolve the Field dates I just formmated them in the query, but I still haven't found a way for the Parameter fields. The date parameters is passed as YYYYMMDD(oracle number data type), and I want to format and display it as MM/DD/YYYY.

Any help would be appreciated,

also would like how to know how this works for the field values as well,

Thanks,
Nick

If you want to change the format of the parameter (assuming that your referring to a date parameter) you can use this one:

=Format(Now(), "MM/dd/yyyy")

Click on the "Tools" then "Report Parameters". Under the Default Values, click on the Non-Queried option then place on the text field the formula above.

Hope this helps..

|||

Thanks for the reply. I'm not sure if I did it the best way, but I ended up using

="From Date: " + Parameters!FromDate.Value.substring(4,2) + "/" + Parameters!FromDate.Value.substring(6,2) + "/" + Parameters!FromDate.Value.substring(0, 4).