Sep 20, 2001 #1 Bammer Technical User Jun 14, 2001 13 US I need an expression that will always give Only the days of the current week when ever I run it. Any assistance would be appreciated.
I need an expression that will always give Only the days of the current week when ever I run it. Any assistance would be appreciated.
Sep 20, 2001 #2 LonnieJohnson Programmer Apr 16, 2001 2,628 US Try this. Just happen to have it in my archieves. Between DateAdd("d",-(Weekday(Now())-1),Now()) And DateAdd("d",7-(Weekday(Now())),Now()) Enjoy! ljprodev@yahoo.com ProDev, MS Access Applications B-) http://www.galaxymall.com/software/PRODEV Upvote 0 Downvote
Try this. Just happen to have it in my archieves. Between DateAdd("d",-(Weekday(Now())-1),Now()) And DateAdd("d",7-(Weekday(Now())),Now()) Enjoy! ljprodev@yahoo.com ProDev, MS Access Applications B-) http://www.galaxymall.com/software/PRODEV
Sep 20, 2001 Thread starter #3 Bammer Technical User Jun 14, 2001 13 US Dude, you rock!!! Upvote 0 Downvote