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 |
|
CoachBarker
Posting Yak Master
170 Posts |
 Posted - 2009-03-25 : 08:09:20
|
| I have 2 fields on a report that are formatted as =format(Fields!PickupDate.Value,"yyyy/MM/dd"). Coming from the data base they are a string (char(8)) 20081231 yyyyMMMdd. When I export the reports to excel, a date in the report is 2009/01/04(yyyyMMdd) but in excel it is 39817. Also on my report I have a textbox formatted as =Today and in excel it is 3983-25-2979. Is there something I can do so when I export I do not have a problem with dates?I have been playing around with it and I find even a field from the data base foramtted as a date does the same thing, suggestions?Thanks for the helpCoachBarker |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-28 : 04:45:35
|
| you may remove format expression and try setting the date format from standard values available from cell properties |
 |
|
|
CoachBarker
Posting Yak Master
170 Posts |
Posted - 2009-03-28 : 12:47:31
|
Your reply to one of my other posts soved this problem as far as the dates in the report. Again much appreciated. Thanks for the helpCoachBarker |
|
|
|
|
|
|
Export to Excel Date format issues