[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 338
  • Last Modified:

Current Week

I am using  a WHERE clause that properly pulls up the current day in a query. I would like a seperate query to pull up the current weeks data. How can I change this code to be the current week?

WHERE (((DateValue(Nz([qryStatsforDailySalesReport].[DateField],#1/1/1950#)))=DateValue(Now())))
0
cansevin
Asked:
cansevin
1 Solution
 
IrogSintaCommented:
See if this works for you:
WHERE Format(Nz([qryStatsforDailySalesReport].[DateField],#1/1/1950#),"wwyy") = Format(Now(),"wwyy")

Open in new window

Ron
0
 
cansevinAuthor Commented:
Thanks!
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now