Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two objects with the exact same data. One is a combo chart, the other a straight table. When I “send to excel” each object, the straight table retains its date format (Sep 2011). However, the combo chart date changes to a numeric format (40787).
Aside from formatting the date as text, how do I retain the correct date format with the combo chart? Why does this work properly for one object and not another? Perhaps a bug?
Assuming this is WAD and will change my date format to force the text formatting when data is sent to excel.
text(MonthName(Date))