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.
this will give you then numeric value of the month
group by that
then place your month name formula in the group field