Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-01-04 : 04:08:09
|
| Hi..In my report I formated datetime filed to show only Date (not time) by using FormatDateTime function.When i export to Excel its taking as Text Field and showing date with single quotes as Prefix.eg: '10-Dec-2009How to show it as Datetime still after exporting to Excel or any other.TIA. |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-04 : 12:56:20
|
Hi.In my opinion, you can have a try of RAQ Report. With it, you can export report to Excel easily without any difference.An example is shown below:  If you like, you can get a free edition at http://www.raqsoft.com/download/install-package/.Regards,behrman. |
 |
|
|
|
|
|
DateTime Format