How do I group by date?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
SAL said:
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.
Click to expand...


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))
 
Back
Top