Specific day query

[gbmarlysis]

Hi,

i have a large table with millions of entries. I want to run a query to return all entries that are on a Saturday. The date stored in the table though is just typical date format eg 15/11/2015.

Any help would be appreciated

Regards

Luke

 

[MarkK]

Checkout the Weekday() function.