How to group by month only when the date field is MM/DD/YYYY

[ZacharyR]

Hi....I need to group records by month only, for all years. The records each have a date field that contains values in the MM/DD/YYYY format. I recognize that i need to use a formula as the group sort order to only grab the month value and ignore everything else

Example of how I want the grouping to look:

January
Apples 1/23/1998
Oranges 1/13/2003
Pears 1/21/2005
Bananas 1/08/2006

I was going to use the month function:

Month(x)

where X is the field in my database that has the date values. When I do this, CR returns a warning that "A constant expression is required here"

Can anyone lend a hand?

thanks

Zach

 

[lbass]

You should not be using the formula for sort order, but actually inserting your group on this formula, which should be created in the field explorer->formula->new area:

month({table.date})

-LB

 

[ZacharyR]

great!...that fixed it..thanks

Zach

 

[remiware]

You can even use MonthName(Month({table.column})) to return the actual month name!

Remington Jarvis
remiWare LLC - remiCrystal Automation Tool

http://www.remiware.com