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

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?
 
K

KARL DEWEY

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])
 
I

Igorin

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

Formula to display next Friday from B1 works except on the Friday itself. 4
BACKING UP LAST WEEK'S EMAIL ONLY 2
query grouping issue 2
Week and days query 8
query separation 3
Last Week, 2 Weeks ago... 2
Fixed column names from a crosstab query. 3
Date question 4

Top