Skip to main content
Inspiring
August 11, 2006
Question

query access database based on day of week

  • August 11, 2006
  • 1 reply
  • 320 views
I have a table that has a field named day, it is populated with the names of
days, monday, tuesday, wednesday etc. How can I query the database based on
the current day of the week. So if today is monday, I want all monday
records. Thanks


This topic has been closed for replies.

1 reply

Inspiring
August 11, 2006
Maybe something like

select * from t where dayfield =format(date(),'dddd')

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004