I want a query to return element from this week

[Grooz13]

I want to get the Price sums of the $ we did this week so I'm trying to query the db where the Sold_Date = this week but i don't know what is the query I must do for the query to every job sold this week

I tried Partdate("w",[mydate])

[Ted C]

I want to get the Price sums of the $ we did this week so I'm trying to query the db where the Sold_Date = this week but i don't know what is the query I must do for the query to every job sold this week

I tried Partdate("w",[mydate])

Sounds like you need something along the lines of...

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

[Grooz13]

thx but I found my answer which is :

PartDate("ee";[Sold_Date])= PartDate(Date()) And Year([Sold_Date]) = Year(Date())