Question
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
+2Hi Tatiana,
welcome to the Celonis Community!
I guess youre getting an error because the DATEDIFF function takes three arguments, but youre only providing two. Besides the time unit, you need to pass two dates for which the time difference should be calculated.
Cheers
David
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.