Predefined date range

  • Thread starter Thread starter Gonzalo
  • Start date Start date
G

Gonzalo

I created a query with a date field, I want the query to give me all records
with a date of Sunday (1) to date()
 
Hi -
Place this in the criteria cell of your date field:
=Date()-Weekday(Date())+1 And <Date()+1

Using this format rather than the Between mode allows for times if in fact
your date field includes both date and time.

HTH - Bob
 
Thanks again for the help, I have a question can add to the statement, If I
run the query on a Monday to give me all records of the previous week, since
I haven't entered any data for the current week.
 
Back
Top