July 27, 2011 at 8:09 am
Hi All
With any report I create, when they are exported to CSV format the date format changes to some kind of numeric format, The dates shows as normal but if I highlight the column and format cells to text I get the below but only on some of the dates.
CUSTREQDTE
06/30/2011
40884.00
07/27/2011
07/28/2011
06/30/2011
06/30/2011
40762.00
06/30/2011
40884.00
I need the date to be formatted properly as I have to sort the spreadsheet by the date and it wont sort properly because of this issue.I have noticed that this is only if the date format is in US format, if I change it to UK Format it exports fine and I can sort with no problem.
I have tried using Convert function (CONVERT(date, DeliveryDate, 'MM/dd/yyyy') AS convdate). I have tried to format the field in TextBoxproperties to no avail.
Anyone got any advise please?
Thanks
R
July 27, 2011 at 12:34 pm
Try using the CONVERT function in your dataset rather than your report.
July 28, 2011 at 1:39 am
Thanks, I have tried it in the data set as well as on the report to no avail.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply