Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

determine last Thursday of month 1

Status
Not open for further replies.
THWatson

THWatson

Technical User
Apr 25, 2000
2,601
CA
Using Access 2003 (2000 format)
What is the method for finding the date of the last Thursday of a given month?

Tom
 
Sort by date Sort by votes
A oneliner way:
=DateSerial(Year([given date]),1+Month([given date]),1)-Weekday(DateSerial(Year([given date]),1+Month([given date]),0),5)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
329
dhookom
dhookom
rdpress
  • Locked
  • Article
Determine if Close Button is Used to Close Form 1
Replies
3
Views
182
Andrzejek
Andrzejek
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
194
caykamanj1966
caykamanj1966
N2Life
  • Locked
  • Question
Last figure in a text box is partially cut off when conditionally formatted as italics 1
Replies
7
Views
209
N2Life
N2Life
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top