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...
 
Back
Top