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-2009
How 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