cancel
Showing results for 
Search instead for 
Did you mean: 

Parsing execution date of processing item to excel error

JonasBertels
Level 3
Hello,   For a process We have developed, we create a custom reporting sheet. In one column we write the date of execution (e.g. 17/06/2018) which we do by first formatting the excel cell to a date format. For every item that has been successfully finished, this does not pose a problem. However, for every case that went in error or Business exception, it sometimes reverses the day and month. (see file attached). e.g. i work an item on 7th June, it will write 07/06/2018 in the cell. However, if it would be an error case, it always writes 06/07/2018, which is very annoying. Can anyone explain why this happens?
1 REPLY 1

RanjeetPatel1
Level 3
Hi Jonas,   Format the date in in BP use dateformater in the same format as sheet, and then write in the excel sheet, this should work for you.   Regards Ranjeet