current week

  • Thread starter Thread starter joao
  • Start date Start date
J

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



------------------------------------------------
Click to expand...
 
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
 
Back
Top