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.
 

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

SQL statement question? 2
Trying to select data range for date/time column 2
GROUP BY weirdness 1
Append Query - return data for each day within a date range 2
Use Table field in query criteria 1
Query using date range entered by user 2
Form Range Query Question 2
Query against dates 21

Back
Top