Filter dates in table that fall on a Saturday

Jaribu

New member
Local time
Today, 16:36
Joined
Dec 30, 2009
Messages
2
I have a table with 8 years of data entered daily. The table has four
columns: AgentCode, IssueDate, Quantity and Price.

I need to apply a filter so that only dates (IssueDate column) that fall on a Saturday are shown.

Any help will be appreciated.
Thanks!
 
Hi -

Welcome to the forum.

In a query of your table, add a calculated field, e.g.:
Expr1: Weekday([YourDateField]) , then
in that field's criteria cell place 7.

That will return only records where the date fell on a Saturday.

HTH - Bob
 
Thanks a million!

Works perfectly.
 

Users who are viewing this thread

Back
Top Bottom