Skip to Content
0
Aug 30, 2023 at 04:05 PM

Table export data issue in date format - SAP Fiori Elements (Analytical Page)

117 Views

Hello Team,

I am using Table as part of Analytical List Page.

Data is provided by OData service auto-generated from CDS view. Date column has "string" type.
If date is missing, OData service returns "00000000" string.
When this value is exported to Excel, it is displayed as 00/01/1900 which is undesirable.

Can anyone please provide solution for this issue?

Please find the attached screenshots for reference.

.blank-data-in-work-item-created-on.png

issue-in-exported-date-format.png

Thanks,

Sabira