Hi guys,
i've created a business process in which:
- with Status as New, a record is added with Stage as New, Start date as current date, end date is null
- when this record Status is changed, end date of previous record is updated to Current date.
Ex:
A Request no 44 is created at 8 am, so Stage: New, Start date: 8am, End date: Null
then at 9 am the status is modified into Approval, so, there are 2 records
1. Stage as New, Start date as 8 am, end date as 9 am
2. Stage as Approval, Start date as 9 am, end date as Nulll
Can you guys help me with this? Many thanks