Grouping by Dates before & after Today's date

  • Thread starter Thread starter Steve C
  • Start date Start date
S

Steve C

I am creating an Access 2003 report based on a parameter query that asks for
a start date and an end date. The dates entered are typically for activities
completed in the last 30 days and ones due in the next 30 days. I want the
report to group on activities older than today's date and after today's date.
I'm thinking I have to build a custom expression in the Sorting and Grouping
dialag box, but I'm not sure how to create it. Thanks for any help you can
give me.
 
Steve said:
I am creating an Access 2003 report based on a parameter query that asks for
a start date and an end date. The dates entered are typically for activities
completed in the last 30 days and ones due in the next 30 days. I want the
report to group on activities older than today's date and after today's date.
I'm thinking I have to build a custom expression in the Sorting and Grouping
dialag box, but I'm not sure how to create it.
Click to expand...


Try using an expression like:

=yourdatefield < Date()

That will have a value of True (-1) for older dates or False
(0) so sorting Ascending will put the older dates before the
upcoming dates.
 
Back
Top