Days until Cash Discount Due date (DIFFDATE formula)

Hello,
I am trying to use the DIFFDATE formula to calculate the days until cash discount but I get an error when I try to run it
datediff(dd, PU_MIN(“BSEG”, “_CEL_AP_ACTIVITIES”.“EVENTTIME”, “_CEL_AP_ACTIVITIES”.“ACTIVITY_EN” = ‘Cash Discount Due Date passed’))

regards
Tatiana

Hi Tatiana,

welcome to the Celonis Community!

I guess you’re getting an error because the DATEDIFF function takes three arguments, but you’re only providing two. Besides the time unit, you need to pass two dates for which the time difference should be calculated.

Cheers
David