month variable from date field

[donbowden]

I am trying to create a month variable from a date field.  I then want to use the month variable to group by month.  I have created a variable called "month" and assigned the formula:

$F{TRAFFICDATE1}.getMonth()

But this returns an error of "cannot cast from int to string".

Please advise if this approach will work for grouping a report based on what month a paricular date field is associated.  Thanks.

 

 

[andfedotov]

getMonth() returns int

 

what you need as a result of your expression is String.

 

So,

 

Integer.toString($F{TRAFFICDATE1}.getMonth())

 

should work for you