Need Some Help Please-how To *include Weekends And Holidays With Previous Work Day (1 Viewer)

fst

Registered User.
Local time
Today, 18:16
Joined
Apr 9, 2018
Messages
46
arnelgp, thanks, i'll check it out today and get back to everyone.
 

fst

Registered User.
Local time
Today, 18:16
Joined
Apr 9, 2018
Messages
46
arenlcp in the query 'qry_saag99_step2, if I put the date #6/01/2020# (Monday), the query result shows all data for that date rather data from 5/29-5/31 (fri-sun)? however, I noticed if I put #5/29/20# in the step2 query it'll combine 5/29-5/31 which is the opposite of what I was looking for. it's close though and appreciate your help on this!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 06:16
Joined
May 7, 2009
Messages
19,169
if today is monday, you Manually put in your query the date for Friday.
it's that simple.
 

Users who are viewing this thread

Top Bottom