Full Version: Always last thursday
UtterAccess Forums > Microsoft® Access > Access Date + Time
AndyNonymous
I'd like to know the code to put in a query for selecting last thursdays date, whichever day you happen to run the query on. Is it even possible? TIA!
jsitraining
Hi
ry
DateField-(Weekday(DateField)+2)
HTH
Jim
AndyNonymous
Thanks very much! That works perfectly.
jsitraining
Glad to help
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.