Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Greetings!
I am trying to find the start and end dates for StaffNo based on a sequence of consecutive dates.
From below table, StaffNo and Work_Date is the input. Output required from script is Start_Date, End_Date
StaffNo | Work_Date | Start_Date | End_Date |
111 | 01-Jan-17 | 01-Jan-17 | 04-Jan-17 |
111 | 02-Jan-17 | 01-Jan-17 | 04-Jan-17 |
111 | 03-Jan-17 | 01-Jan-17 | 04-Jan-17 |
111 | 04-Jan-17 | 01-Jan-17 | 04-Jan-17 |
111 | 08-Mar-19 | 08-Mar-19 | 11-Mar-19 |
111 | 09-Mar-19 | 08-Mar-19 | 11-Mar-19 |
111 | 10-Mar-19 | 08-Mar-19 | 11-Mar-19 |
111 | 11-Mar-19 | 08-Mar-19 | 11-Mar-19 |
222 | 13-Apr-18 | 13-Apr-18 | 17-Apr-18 |
222 | 14-Apr-18 | 13-Apr-18 | 17-Apr-18 |
222 | 15-Apr-18 | 13-Apr-18 | 17-Apr-18 |
222 | 16-Apr-18 | 13-Apr-18 | 17-Apr-18 |
222 | 17-Apr-18 | 13-Apr-18 | 17-Apr-18 |
222 | 29-Dec-19 | 29-Dec-19 | 08-Jan-20 |
222 | 30-Dec-19 | 29-Dec-19 | 08-Jan-20 |
222 | 31-Dec-19 | 29-Dec-19 | 08-Jan-20 |
222 | 01-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 02-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 03-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 04-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 05-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 06-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 07-Jan-20 | 29-Dec-19 | 08-Jan-20 |
222 | 08-Jan-20 | 29-Dec-19 | 08-Jan-20 |
Hi I use scripts to meet your requirements.
Hi I use scripts to meet your requirements.
Hi Alex00321
This works perfectly. Thank you very much.