Spreadsheet: 738311d1624964168-extracting-position-change-dates-in-employee-data-sample
Sheet: POSITION DATES

Pers.no. | Name Last Name | Beginning Date | End Date | Position
310 | [NAME] | 2015-07-01 00:00:00 | 2015-10-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2015-11-01 00:00:00 | 2015-12-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2016-02-01 00:00:00 | 2017-07-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2017-08-01 00:00:00 | 2017-10-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2017-11-01 00:00:00 | 2018-12-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2019-01-01 00:00:00 | 2020-11-30 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2020-12-01 00:00:00 | 2020-12-31 00:00:00 | SENIOR SPECIALIST
310 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
313 | [NAME] | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-02-01 00:00:00 | 2016-03-31 00:00:00 | SPECIALIST
313 | [NAME] | 2016-04-01 00:00:00 | 2016-09-30 00:00:00 | SUPERVISOR
313 | [NAME] | 2016-10-01 00:00:00 | 2017-01-31 00:00:00 | SUPERVISOR
313 | [NAME] | 2017-02-01 00:00:00 | 2017-06-30 00:00:00 | SUPERVISOR
313 | [NAME] | 2017-07-01 00:00:00 | 2020-12-31 00:00:00 | SUPERVISOR
313 | [NAME] | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | SUPERVISOR
318 | PETE PACKETT | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2016-02-01 00:00:00 | 2017-01-31 00:00:00 | SUPERVISOR
318 | PETE PACKETT | 2017-02-01 00:00:00 | 2017-04-30 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2017-05-01 00:00:00 | 2017-06-30 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2017-07-01 00:00:00 | 2017-09-30 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2017-10-01 00:00:00 | 2020-06-30 00:00:00 | SENIOR SPECIALIST
318 | PETE PACKETT | 2020-07-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2016-01-01 00:00:00 | 2016-05-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2016-06-01 00:00:00 | 2017-07-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2017-08-01 00:00:00 | 2018-09-30 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2018-10-01 00:00:00 | 2018-10-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2018-11-01 00:00:00 | 2018-12-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2019-01-01 00:00:00 | 2020-12-31 00:00:00 | SENIOR SPECIALIST
326 | LENA SMITH | 2021-01-01 00:00:00 | 9999-12-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2015-07-01 00:00:00 | 2015-12-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2016-01-01 00:00:00 | 2016-01-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2016-02-01 00:00:00 | 2016-05-31 00:00:00 | SENIOR SPECIALIST
328 | [NAME] | 2016-06-01 00:00:00 | 2017-01-31 00:00:00 | SUPERVISOR
328 | [NAME] | 2017-02-01 00:00:00 | 2017-06-30 00:00:00 | SUPERVISOR
328 | [NAME] | 2017-07-01 00:00:00 | 2017-12-31 00:00:00 | SUPERVISOR
328 | [NAME] | 2018-01-01 00:00:00 | 2020-11-30 00:00:00 | SUPERVISOR
328 | [NAME] | 2020-12-01 00:00:00 | 9999-12-31 00:00:00 | SUPERVISOR