format parameter date

Hi,

I know how to format report items (dd/MM/yyyy) but how can i format a parameter in the format dd/MM/yyyy?

The current format is MM/dd/yyyy.

Thanks

Dim dt as String= "21/11/2007"

dim dtdate asa date

dim s() as string=dt.Split("/")

dtdate = s(1) & "/" & s(0) & "/" & s(2)

msgbox(dtdate)

Urs,

|||

Thanks for the response. I am not sure where to put the code in the reporting services. I have parameters in the report but i am not sending any parameters to the report from aspx.

|||

Scroll down to Figure 17 on this pagehttp://www.eggheadcafe.com/articles/20040823.asp

Orhttp://msdn2.microsoft.com/en-us/library/ms157328.aspx

|||

Hi,

What I need to format is the report parameter date (the value of the prompt) and not an actual textbox. In the prompt value the default dates appear in the format MM/dd/yyyy and i need the dates to appear as dd/MM/yyyy.

from_date to_date

|||

from_date 10/30/2007 to_date 12/30/2007 view report