SAP Knowledge Base Article - Public

3381844 - Incorrect data format in fields "Start of Life" and "End of Life" within app Review Purchase Order Accruals


The "Review Purchase Order Accruals" application's export function produces unreadable date formats for the "Start of Life" and "End of Life" fields.



Reproducing the Issue

Export the excel file in app "Review Purchase Order Accruals.


This date format issue can be resolved using an Excel formula. To convert the incorrect date fields (assuming $G2 represents the cell containing the incorrectly formatted date), insert the following formula:

=( MID($G2, 7, 10) / 86400)  + DATE(1970, 1,1) 

Remember to change the cell format to "Date". Then apply this formula and format to the entire column by dragging the mouse from the cell with the inserted formula downwards.

The fix is planned with CE2308.3, please test again on 13th November. Please note this is only a planned date and could be changed later.


Review Purchase Order Accruals, export, data format, "Start of Life", "End of Life". , KBA , FI-GL-GL-POA-2CL , Purchase Order Accruals (Public Cloud) , Problem


SAP S/4HANA Cloud 2308