Parsing execution date of processing item to excel error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-06-18 06:20 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-06-18 09:37 PM
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
