Ok, so this will be a little long winded. I'm looking to calculate on a couple of different items for offboarding employees in my company, the parameters are below and I'll go through what I'm trying to get afterwards.
Parameters:
Offboarding Ticket Opened/Creation Date
Employee Leave Date
Account Disabled Date
Offboarding Ticket Closed Date
Currently I am calculating how long it takes to do the following - in days (all of these are working):
How long from employee leave date to close ticket (Datediff employee leave/ticket close)
How long from employee leave date to disable account (Datediff employee leave/account disabled)
Notification time between ticket opened date and employee leave date ((Datediff ticket opened/employee leave)
What I am now trying to do is the following:
If employee leave date is older than ticket opened date*, calculate time to close ticket and to disable account from ticket opened date, if ticket opened date is older than employee leave date, calculate time to close ticket and to disable account from employee leave date.
*Essentially some of the offboarding tickets are being raised after the employee has left, so although I still want to know how long it takes to close the account, I want to know this in terms of when we were informed that the employee has left which would come from the ticket opened date, BUT only in the case that the ticket opened date is AFTER the employee leave date. If the ticket opened date is BEFORE the employee leave date then I want to calculate on this.
Hope that makes sense. Let me know if anyone requires more information.
