Want 3rd Thursday of each Month

  • Thread starter Thread starter JH Hill
  • Start date Start date
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!
 
DateSerial( desiredYear, desiredMonth, 15) + Choose( DatePart("w",
DateSerial( desiredYear, desiredMonth, 1)), 4, 3, 2, 1, 0, 6, 5)


should do.


Vanderghast, Access MVP
 
Back
Top