Exporting Dates to Excel as date format

Hi,

I'm currently having problems exporting formatted dates from reporting services 2005 to excel.

Basically what I require is a way to format a date in reporting services so that it only shows the date without the time (preferably british format) and when it is exported to excel it is still formatted as a date.

This is so the user can sort the data file via date, I appreciate it is easy to select the column and format the cells but i would prefer to have a 'cleaner' solution to this problem which avoids the need for users to be formatting exported reports.

Originally I was formatting the dates as convert(varchar,@.date,103) in the SP which converts it to a character string and excel picks this up as a character as would be expected. So I changed this to a date and set about trying to format the date in Reporting Services, so far i've been unsuccesfull using cdate (brings back the time) and format as it again converts it to a character string.

Any help or advice would be greatly appreciated,

R

i had the same problem before,

i inserted a space before the mm/yyyy when after converted it into char.

it should work

sql

Export to Excel: Date formatting issue

When I export my report to Excel, the dates in the report are formatted as
text and need further work before they can be manipulated as dates by
formulae.
Is there a method to export the dates so that they arrive in my Excel
worksheet as date formatted cells?
Thanks for any help.What about the CDate function?
"MarkC" wrote:
> When I export my report to Excel, the dates in the report are formatted as
> text and need further work before they can be manipulated as dates by
> formulae.
> Is there a method to export the dates so that they arrive in my Excel
> worksheet as date formatted cells?
> Thanks for any help.

Export to Excel - Number formatted cells export to Excel as 'General' ?

Anyone know why cells within a matrix that are formatted as numeric export to Excel with a cell format proprty of "General"? Cells within a table however export with an appropriate format.

Thanks

Try converting the data within the cell - something like cdbl() or cint() may work.