How do I calculate the last Sunday of the month in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to pull all of the records whose finish dates are between today and
the last Sunday of the month.
Thanks for any help you can provide!
 
Beween Date() and
DateAdd("d",1-Weekday(DateSerial(Year(Date()),Month(Date())+1,0)),DateSerial(Year(Date()),Month(Date())+1,0))
 
Thank you very much! It works great!
-Jenny

John Spencer said:
Beween Date() and
DateAdd("d",1-Weekday(DateSerial(Year(Date()),Month(Date())+1,0)),DateSerial(Year(Date()),Month(Date())+1,0))
Click to expand...
 

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

Last day of month that isn't saturday or sunday 3
Count Weeks in a Month 7
Last day of month is saturday or sunday? 2
Query records with single Dates Automatically 9
Counting calendar Days - not including Sundays 3
Every Sunday Between Two Dates 2
Determining the Sunday date of the third "full" weekend of a month 25
Saturdays and Sundays 2

Back
Top