Query: Current week selection

[sabrecoach]

Hi everyone

Stuck in 35cm of snow but still working. I would like to know what formula would I have to put in a query to select records that are in the current week that starts on monday.

Here's an example. with dates and invoices numbers. I want to have the invoice that were produce this week (i.e. we're dec. 16th)

05/12/08 A12459
05/12/09 A12460
05/12/12 A12461
05/12/12 A12462
05/12/12 A12463
05/12/14 A12464

Results should be between A12461 and A12464

Thanks

Patrice
MTL, Canada

 

[Norie]

Is it Monday to Friday?

Try this for the criteria for the date.

Between DateAdd("d",2-Weekday(Date()),Date()) And DateAdd("d",7-Weekday(Date()),Date())

 

[sabrecoach]

Hi Norie,

Thanks a lot

It's from monday to friday. My access is in french, I had a hard time finding the right syntax, but now it seem to work.

Could you explain me something?

2-Weekday(Date()),
7-Weekday(Date()),

What are the first digit stand for? I'm curious

Patrice

 

[Norie]

Patrice

There's actually an error 7 should be 6.

They just represent days of the week.

2 I think is Monday and 6 Friday.

So the calculations just work out how many days to subtract to get Monday's date (4) and how many days to add to get Friday's date (0).

 

[sabrecoach]

Thanks Norie for the explanation