selecting records since a certain date
- From: "Jerry Crosby" <jerry.crosby@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Jul 2005 10:13:26 -0700
I have a table with a date field. I want to select all the records with a
date newer than the previous June 30 (July 1-June 30 is our fiscal year).
Because it spans calendar years, I can't just say, "go back as far as July
of this year." (e.g., if it was February 12, 2005, I'd want it to select
all records with a date newer than June 30, 2004).
How do I code the query to accomplish this?
Jerry
.
- Follow-Ups:
- Re: selecting records since a certain date
- From: Rick Brandt
- Re: selecting records since a certain date
- Prev by Date: Re: unexpected exponential results on a sum field
- Next by Date: Re: Latest equipment settings
- Previous by thread: ACCESS
- Next by thread: Re: selecting records since a certain date
- Index(es):