Date today to end of week

[torquay]

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

 

[namliam]

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 !

 

[torquay]

Thank you for your speedy reply.


Works great

Kim

 

[namliam]

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

*POOF*
Its weekend !