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?