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

Jennyrd · Aug 15, 2006

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!

John Spencer · Aug 15, 2006

Beween Date() and
DateAdd("d",1-Weekday(DateSerial(Year(Date()),Month(Date())+1,0)),DateSerial(Year(Date()),Month(Date())+1,0))

Jennyrd · Aug 17, 2006

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))