how to calculates dates between two records in 2001
I have requirement where i have to get working days between two leaves of an employee,
ie. i want to get the duration(Period) of the working days from the joining date of first leave to the that of
start date of next leave of the emplyoee---in PA30 i hae below example
ex 01-01-2008 to 06-01-2008. -> first leave period of the employee in january
09-01-2008 to 14-01-2008 -> second leave period of the employee.
in the above example 07-01-2008 is the re-joining date from his first leave and he will
work till 08-01-2008 and will be leave again from 09-01-2008 .
how to get the duration of the working days as 07-01-2008 to 08-01-2008.
when we are reading this record in a loop i have first record as 01-01-2008 to 06-01-2008 and second
record as 09-01-2008 to 14-01-2008 how can i calcuate the next date from the first record to that of
the last working day (08-01-2008) ...............
iam not able to get from this two records the actual working days of the employee.
please help me regarding this