current week

[joao]

Hi,

how can i make a query to return the values in the current week? (i
have a field with the date) (i know how to get the values betwen two
dates, but not the current week autonatically)

Thanks

 

[Jason Trolian]

between#10/20/2003#and#10/31/2003#

-----Original Message-----
Hi,

how can i make a query to return the values in the current week? (i
have a field with the date) (i know how to get the values betwen two
dates, but not the current week autonatically)

Thanks



------------------------------------------------

 

[Dale Fye]

Take a look at the DatePart function.

SELECT *
FROM yourTable
WHERE DatePart("yyyy", [dateField]) = DatePart("yyyy", Date())
AND DatePart("ww", [DateField]) = DatePart("ww", Date())

--
HTH

Dale Fye


Hi,

how can i make a query to return the values in the current week? (i
have a field with the date) (i know how to get the values betwen two
dates, but not the current week autonatically)

Thanks

 

[Peter Surcouf]

where format(yourdatefield,"yyyyww")=format(date(),"yyyyww") should work.