HI - We are using SSRS 2008 R2. We have date displaying something like "28 May 2012" in browser. When we export to Excel it is displaying as same fortmat, i.e "28 May 2012". However, when we export the report to .CSV format it is displaying as 05/28/2012. We have no clue why it is coming like that. We want date to be displayed as "28/05/2012" in CSV format. Is there any way can we control date format in .CSV format. We have Language property as "en-AU" for Report. Please advise me on this issue Thanks

Hi, You can do this in R2, with help of below expression. =IIF(Globals!RenderFormat.Name="CSV",Format(Fields!DateValue.Value,"dd/MM/yyyy") ,Format(Fields!DateValue.Value,"dd MMM yyyy")) Please note that, you need to replace Fields!DateValue.Value the filed name in above expression at two places with your dataset field name. -Chintak.

Great!! It worked. Thanks a ton for timely response. Thanks