3282401 - SAC date format issue while export to excel

You are exporting content from a SAC table to file type XLSX.  The format of the date column in the table is set as per user profile.  However, this format is not applied if the user selects 'ALL' for the filter.  The data format changes from the set format, as per profile, to a different format, for example from mm/dd/yyyy. (11.01.2022) to mmm/dd/yyyy (Nov 01, 2022).

SAP Analytics on Cloud

1. Confirm date format is set, e.g. as mm/dd/yyyy in the user's profile setting
2. Open a story and confirm the date format in the table is as profile setting
3. Right click in the story, from the drop down select Table Functions->Export
4. Select filters for the export
   1. File Type: XLSX 
   2. Select the filter value of 'All'
     
5. Click OK after export completes open the Excel and check the date column in the new Excel file.  The date format is changed to MMM/dd/yyyy

The export 'ALL' feature does not take profile settings into account when exporting. This is a limitation/feature gap and well-documented in https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/ff5f1e052b5e400da990dad8408604da.html 

Since this is a limitation, we treat his request as a feature request for future development efforts. We make our development efforts transparent by providing a roadmap explorer here: https://www.sap.com/products/roadmaps.html
The best way to influence our roadmap is by providing us feedback using the influence portal described in the KBA 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? - SAP for Me 

KBA 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? - SAP for Me 

Product Roadmap

date format xlsx export filter  , KBA , LOD-ANA-TAB , Table , Problem