Last day of the month logic | Community

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

Page 1 / 1

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

Reply