How do I group by date?

[Guest]

I have set of records for various dates of years and months. I would like to
create two groups. First group, I want all records more than thirty days of
month end Calendar month and other Less thrity days from month-end calendar
of current period.

i.e. Today is date is July 14, but I am working on month-end June 30. My
data is from beginning of time thru June 30, 2005. How can I just get two set
of groups from one query on the same report.

 

[Marshall Barton]

I have set of records for various dates of years and months. I would like to
create two groups. First group, I want all records more than thirty days of
month end Calendar month and other Less thrity days from month-end calendar
of current period.

i.e. Today is date is July 14, but I am working on month-end June 30. My
data is from beginning of time thru June 30, 2005. How can I just get two set
of groups from one query on the same report.

You can use an expression in the report's grouping.

I don't see how you define the month end date, but the
expression might be something like:

=(datefield < DateSerial(Year(Date()), Month(Date()) - 1,
-30))