Skip to main content
The result of the MONTH() function is a number (1-12). However, we would like to show this a jan, feb, etc. Is there a function/way to do this easily (were on-premise 4.5) that Im overlooking, or should I build a custom formula to do this translation?

I found a (partial) solution. In the 4.3 version documentation there is detailed information on the formatting options (https://help.celonis.de/display/C4E/Date+Formats

).

Tip: It would be nice if this list would make it to the 4.5/4.6/IBC/SNAP documentation.

In my case %b is the solution, which formats a date as an abbreviated month name.

However, now Im looking at how to sort this correctly, i.e. jan, feb, mar etc.

My current function is ROUND_MONTH() because this still returns a date format. But when sorting, it does not result in the desired order. Im looking for ideas on how to solve this.


Hi,
regarding the sorting of the month, I could just think of a workaround like Maxi has suggested in this post.
For the feature proposal, I recommend to raise a feature request.
Best regards,
Viana

Reply