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
Page 1 / 1
Hi 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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.