Month format not working

[danikuper]

My report is reading from a table where I have a field called month with numbers from 1 to 12 representing the month of the year (field type is number).

The report groups data by month and is working fine, and it shows months as numbers (1..2...etc). When trying to change the format properties for the month field in my report ("mmm"), it screws up by showing "Dec" where I had number 1, "Jan" where I had number 3 and so on...

any idea of why this is happending and how to solve it? Will changing the format properties to "mmm" work only if my field type is "date/time" ?

thanks in advance!!!!

 

[Newman]

It shows the months in an alphabetical order.
So, December is the first and January is the third. (February being the second).
To get them in order, use a query instead of using the table (should always do that anyway) then create a field called AlphaMonth where you have your months formated in text, and one called MonthNumber where you leave month in numeric format.
On your report, show the AlphaMonth field, but use the MonthNumber in the GroupBy.

 

[danikuper]

Yes, initially I also thought it was ordering the months alphabetically however looking at it closely I saw that Jannuary was being repeated several times. I also added the "month" filed in its original format to see how the numbers were being translated and it is just crazy: 1 is December, 2 is Jannuary, 3 is Jannuary again... and so on!

 

[Newman]

Yeah! I found my mistake later on. Else April and August would have been first... Sorry!
I have no idea yet... will take a look at it later on. Good luck!

 

[Newman]

Hi!
I had no time to look at it last week. (Everyone is on vacations so I have twice the work to do.) Just wanted to know if you found out about your months problem.

 

[danikuper]

Hi,

No, I'm still stuck! Any help is greatly appreciated

daniel