Inconsistency in the date format between Clarity action 'Export to Excel' and 'Export to Excel (Data Only)'. The expected format after export is 'dd/mm/yyyy' .
The 'Export to Excel' generates output in a formatted spreadsheet that makes it easier for users to see the data and the output is limited to a maximum amount of data using the number of columns and rows generated by the source query. The 'Export to Excel (Data Only)' option generates output formatted as simple data.
Steps to Reproduce:
Expected Result: Date format for 'Export to Excel(Data Only)' should be 'dd/mm/yyyy'
Actual Result: 'Export to Excel (Data Only' Date format is 'dd/mm/yy'
Format the column in the Microsoft Excel after the output is generated.
Format cells: date format = dd/mm/yyyy
Resolved in CA PPM 14.1