Calculate last working date of the employee by using the joining date of an another organization

[Brownie]

i need to calculate the end date of  employee 1 of IT (11/30/2005 )using the start date of  SALES 12/1/2005 [mm/dd/yyyy]

[Mark_Little]

HI @Brownie 

You are going to need to look at the PEEK function. Make sure that the Data is loaded in the correct order (I would normally do Employee if, Start date asc )then using something like,

IF( [Employee ID] = PEEK([Employee ID],+1), PEEK([Start Date],+1),[End Date]) AS [End Date]

[Brownie]

using that didn't give me the desired result. 

[Brownie]

i think using interval to count the days and then -1 from it might do the trick