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


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