1st Wednesday in a month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using a query I have been trying to replicate the third occurence of
wednesday in any given month. eg in Jan 2006, the third wednesday = 18th
I can find the first date and the last date of any month, but not
specifically, the wednesday.

Okay, so I can look on a paper calender, but I want to automate.
Please help.
 
HSG said:
Using a query I have been trying to replicate the third occurence of
wednesday in any given month. eg in Jan 2006, the third wednesday = 18th
I can find the first date and the last date of any month, but not
specifically, the wednesday.

Okay, so I can look on a paper calender, but I want to automate.
Please help.
Click to expand...

http://groups.google.com/group/comp.databases.ms-access/msg/3c3b63d850f03a05

Note that the function returns the day in the month rather than the date
itself. The DateSerial function or the DateAdd function (with the day
number minus one) can be used if the date is required.

James A. Fortune
(e-mail address removed)
 
Back
Top