Variable Pay Mass Update Job - Not updating # of days correctly

[BalajiNudurupat]

Hi Team,

We have a field on our variable pay template history section where it stores the # of days of each assignment row. 

We started the cycle few days back and with the help of SAP SF, we scheduled Employee History job along with update worksheets and another job to perform mass update and this job type is "Variable Pay Mass Update Job". Prior years, this used to update the field correctly but this year, it is not updating that field correctly.

For ex: one of the assignment has start date as 12/31/2022 and end date 12/31/2023. The job is calculated the # of days as 366 instead of 365 as it considers 12/31/2022 as well. Whereas in prior years, it used to calculated 365 correctly.

Anyone facing this type of issue and how this was resolved.

Guidance appreciated.

Best Regards,

Balaji

[xavierlegarrec]

Hi @BalajiNudurupat 

There is no standard field that calculates the number of days by assignment so this number of days is calculated through a custom field at the assignment level.

Can you please share the formula in the assignment level custom field of that field ? 

All the best

Xavier

[BalajiNudurupat]

Hi @xavierlegarrec :

Yes, it is a custom field and here is the formula used on it. dateDiff(customStartDate,customEndDate)+1

And at the summary level, the same field is used to calculate aggregate value.

Please let me know for any additional information.

Thank you.