Query "From last week's Friday to this week's Thursday"

  • Thread starter Thread starter Igorin
  • Start date Start date
I

Igorin

Hello,

I need to create a query that will be generated every Friday morning.

This query should look up all values for the period between last week's
Friday and the current week's Thursday.

Is this possible?
 
This will do it if your dates do not have time with them --
Between Date()-8 And Date()-1

If so, then you need a calculated field like this ---
Expr1: DateValue([DateTimeField])
 
Thank you very much, Karl!

--
igor


KARL DEWEY said:
This will do it if your dates do not have time with them --
Between Date()-8 And Date()-1

If so, then you need a calculated field like this ---
Expr1: DateValue([DateTimeField])

--
KARL DEWEY
Build a little - Test a little


Igorin said:
Hello,

I need to create a query that will be generated every Friday morning.

This query should look up all values for the period between last week's
Friday and the current week's Thursday.

Is this possible?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week starts on Friday 2
Week and days query 8
Friday's Due Date 2
Week, monthly, quarterly 2
Query from day of week 3
Weekly count 3
Display 4 weeks of data 10
number of records per week 2

Back
Top