Date query

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

Guest

I am trying to write a select query to return records within 10 days of being
due. For example, my field name is SA_To_Be_Mailed_Date. I would like to
have a query that lists the records that have this date within 10 days of the
current date. I'm not sure how to write the criteria for this date field to
return these records.

I don't want records where that SA to be Mailed date is in the past either -
does that make sense? This should be a tickler file for things that are
coming due.

Thanks!
 
I am trying to write a select query to return records within 10 days of
being
due.
Use this as criteria --
<Date()-10
If you have a Completed field that you flag then use a criteria on that
field also.
 
Open the query in design view. Try the following criteria.

Field: SA_To_Be_Mailed_Date
Criteria: Between Date() and Date() + 10
 
Back
Top