Forum Discussion
continuous employment date
I have this data set :
| Emp# | FY | Job | Start |
| 1 | 2017 | A | 7/1/2016 |
| 1 | 2016 | A | 7/1/2015 |
| 1 | 2015 | B | 7/1/2014 |
| 1 | 2014 | A | 7/1/2013 |
| 2 | 2017 | C | 7/1/2016 |
| 2 | 2005 | C | 8/3/2015 |
| 3 | 2017 | A | 7/1/2016 |
| 4 | 2017 | A | 7/1/2016 |
| 4 | 2016 | A | 7/1/2015 |
| 4 | 2015 | A | 7/1/2014 |
| 4 | 2014 | A | 7/1/2013 |
I want to find the ealiest continuous employment date for an employee in a current job ( FY2017).
Example:
* emp#1 had job A in Fiscal year 2017, the earliest continuous employment date for job A will be 7/1/2015 ( not 7/1/2013)
* emp# 2: the continuous employment date will be 7/1/2016 ( not 8/3/2015)
* emp#3 : 7/1/2016
* emp#4 : 7/1/2013
Thank you.
No RepliesBe the first to reply