Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BarbCline
Contributor III
Contributor III

Send to Excel date format inconsistency

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?

1 Reply
BarbCline
Contributor III
Contributor III
Author

Assuming this is WAD and will change my date format to force the text formatting when data is sent to excel. 

text(MonthName(Date))