First Thursday of a range

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a query that uses RecordDate to show records within a specified
Startdate and Enddate. I am trying to create a field that shows the first
"Thursday" within the start and end dates. It is not a easy as it
sounds...or maybe I am making it harder than it is!
 
Use WeekDay(). The 2nd argument lets you specify that your week starts on a
Thursday. Sutract from the date/time field.
 
Back
Top