I need new tenure days when title has changed to the employee

[hemachandran]

I have attached the sample data. In that data i have month wise data at the month end.I have tenure days based on the DOJ. When the employee changes from one position to another position the DoJ has to change when changed date of the title. And it has to be the DOJ.

From that date i need new tenure days for the current position. please help on this..

Thanks in Advance..

[sunny_talwar · Accepted solution]

I think there is an issue with your DOJ date format and CalDate format. DOJ is actually formatted as M/D/YYYY in the Excel file. Can you try loading this one

[hemachandran]

Thanks Sunny For your Quick Response..