Skip to main content
Hi, Is there any way in Celonis to show last day of that month based on a particular date column. Example- We have below values in a date column 13-Feb-2020 5-May-2020 28-May-2020 17-July-2020 4-Aug-2020 and, We would like to see below values as an output 29 31 31 31 30 Thanks, Amogh
Hi Amogh, You can use DAYS_IN_MONTH(table.colmn) to get the last day of the month. Thanks!! Pooja
Hi Pooja, Thanks for the suggestion however when I tried, I got Invalid Operator type DAYS_IN_MONTH error. We are using Celonis 4.5 on prem system. Regards, Amogh
Community Code of ConductAccessibility statement