10 Replies Latest reply: Aug 12, 2011 3:30 AM by Peter Driscoll RSS

    Send to Excel converts date to text

    Peter Driscoll

      Hi,

       

      I am using monthname(datefield) to display the month and year as a dimension in a chart and then using sort by numerical value to put these in date order. We recently upgraded our server and clients to V10 SR3 and since then when pressing teh 'Send To Excel' icon in the caption the date dimensino comes out as text in Excel. Before the upgrade it used to come through as a number (the excel internal date).  Any idea on how I can get V10 to produce dates/numbers on the send to excel again?

       

      Thanks