Query Based on Last Friday

[OOzy]

Guys/Gals,

I need to find all records that were entered in the database since last Friday.

 

[dcurtis]

Build a query with the criteria field for the day/date you are looking for greater than the date for "last friday

 

[dcurtis]

Expanding on my reply, is this something that has to run each week, looking for items since "last friday"?

 

[PHV]

SELECT *
FROM yourTable
WHERE [date field] > (Date() - Weekday(Date(), 6))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[OOzy]

Yes, I have a database that has action items for my team. Each week I print this action item list showing closed and open actions. But, I don't like the closed items to show every week. I would like the closed items to show for only on week.

Thank you