how to calculates dates between two records in 2001

[Former Member]

Dear Freinds,

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

regards

madhuri

[Former Member]

What kind of time management you are following?

Based on that we can decide If you following postive time mangenment.

Query on Pa2001 for absences and pa2011 for attendances.

compare there two you will get actual working days

If it is negetive management

you need to query on pa2001 absences and pa2000 for attendances compare both you will get result

Best Regards

[Former Member]

Hi

To get the duration of the working days as 07-01-2008 to 08-01-2008. to get Number of attedance hours

you can check cluster PCL2 (PT66), PT table or

Table PA2002.

Cheers,

Chakri