How to Get Employees Period in Company as per Employee Joini

Question

--How to Get Employees Period in Company as per Employee Joining Date

Example, I have a field

Emp_Number,      Emp_Name,      Emp_JoiningDate     Period Start     Period End

A-1                      Alex                       2013-07-14           2017-07-14      2018-07-14

A-2                      Sachin                    2017-08-14          2017-08-14      2018-08-14

 

 

Thanks

Basit