Skip to main content

Dear Colleagues,

a simple question regarding function ADD_MONTHS. Is there a way to include in it leap year? I am calculating an expiry date for certain financial documents using formula:

ADD_MONTHS ( ROUND_DAY(TO_TIMESTAMP(RBKP.BLDAT,YYYY.MM.DD)),3)

So expiry is after 3 months of document date and if it is 29.11.2019, then the result should be 29.02.2020 instead of 28.02.2020. In excel we have function EDATE. Can we achieve something similar in Celonis?

Hi ksitarsk,

thanks for reaching out!

ADD_MONTHS should already respect leap years. I have reproduced the behavior you describe, and I think that it should in fact return 29.02.2020.

We will follow up on this and fix the issue.

All the best

David


Reply