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?