I am trying to pull records from today to the end of the week, when I try the code below I get everything from this week, can anyone advise me.

DatePart("ww", [ApptDate]) = DatePart("ww", Now()) and Year( [ApptDate]) = Year(Date())

Thanks Kim

Between date() and date() - weekday(Date(),2) + 7

Date() obviously returns today, weekday for today will return 5.
14-Nov - 5 + 7 = 16-Nov

Happy programming !

Thank you for your speedy reply.


Works great

Kim

Working 'magic' with dates is my specialty...

*POOF*
Its weekend !