Hi, In SSRS report i have date format as "2009-03-06 00:00:00.000". I want to show the date as Mar 06, 2009. I know how to write in SQL statements. But, I want to handle this in SSRS report level. Any one pls tell me how to do. Thanks, Abdul2010

Hi, Better to do it in yourquery and just display in Report.-------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

but if you want to do in report do this =format(Fields!DATE.Value,"MMM dd,yyyy" ) -------------------------------------------------------------------------------- Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Maqbool.

Thank you Maqbool...