Want 3rd Thursday of each Month

J

JH Hill

Is there an easier way? Currently use in a query:
1.) DatePart("w",[DateList]) = 5
and
2.) Day([Datelist]) = Between 15 and 21
and
[DateList] is the field name in a table with MANY dates.


I currently use in an "Update Query" to set values for (in this case) the
THIRD THURSDAY or each month. This works fine. I was just wondering if there
was a simpler way. Thanks!
 
V

vanderghast

DateSerial( desiredYear, desiredMonth, 15) + Choose( DatePart("w",
DateSerial( desiredYear, desiredMonth, 1)), 4, 3, 2, 1, 0, 6, 5)


should do.


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

General Date problem 4
Query that changes each month 2
VLOOKUP 1st Friday in April and So On 1
3rd Thursday of each month 3
Find Unmatched Data for several periods of time 4
DatePart in Parameter Query 2
Running Month to date query 6
Excel Message box with days of month & date. 1

Top