Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Month forumla

i have a table that includes dates and times in numerical format and i am using a table to pull the month from this field using the following formula MonthName(month(),true) with the data being shown in a a cross tab. The problem is the months are shown in alphabetical order and i would like it to be sorted by order of the calender. Any suggestions? Of course if i show the field in numerical order it is correct but i prefer it to show by month name.

Former Member
Former Member replied

datepart('m',cdate({Pr_po_rcpts.Crt_Dte}))

this will give you then numeric value of the month

group by that

then place your month name formula in the group field

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question