Last day of the month logic

Technical Implementation Analysis
#1

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

#2

Hi Amogh,

You can use DAYS_IN_MONTH(table.colmn) to get the last day of the month.

Thanks!!
Pooja

1 Like
#3

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