First Thursday of a range

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!
 
A

Allen Browne

Use WeekDay(). The 2nd argument lets you specify that your week starts on a
Thursday. Sutract from the date/time field.
 
Top