Loading

RDL-Report file - Date format need to change

Kavitha M

Hi friends,

I have a report with fromdate,todate,userid as parameters. But when i run my report it shows the following error.

And also,when i select date from calender it shows as '25-May-14'.But actually i want it as '05/25/2014'. I tried this one =FORMAT(Parameters!FromDate.Value,"dd/MM/yyyy")

But it doesn't works. Can anybody help me to solve this

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed12y ago
Hi, if you are using a store procedure to get the data from database so apply date formating in
SQL server.
or in rdl you can try this
CDate(Parameters!FromDate.Value,"MM/DD/yyyy")