Skip to main content
Question

Last day of the month logic

  • December 31, 2020
  • 2 replies
  • 60 views
.
Level 5
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 replies

P
Level 2
Forum|alt.badge.img+7
Hi Amogh, You can use DAYS_IN_MONTH(table.colmn) to get the last day of the month. Thanks!! Pooja
.
Level 5
  • .14600906
  • Author
  • Level 5
  • January 8, 2021
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