Comparing Dates in PCR

[Former Member]

Dear Experts;

I need to compare the date of a field in IT0041 "03" with the termination date of the employee and check if the date in 41 is after the termination date then the employee should pay a specific amount based on the number of days difference.

Kindly help me know how can i do this.

Thanks in advance.

Regards;

Lobna

[former_member193210 · Accepted solution]

You should be able to use Payroll Operation NUM to identify the number of days between the termination and the end of the current Payroll Period and the number of days between the date 03 on IT0041 and the end of the current Payroll Period, transfer each of these values into a different Temporary WTs, and then identify the difference between these 2 Temporary WTs. As for the "specific amount", it could be assigned directly in the pcr (as in AMT=100) or through a constant from V_T511K.

Try to create the pcr, and if you have problems, post a screen capture of it and of the section of the Payroll Schema where you inserted it (so that it shows the Function calling the pcr and the values in Par2 and Par3).

[JohnWick]

Hi Lobna, please read the documentation attached. Maybe you can use the operation NUM reading type of date in IT0041.

it0041.txt

Hope this helps