Working with Dates

  • Thread starter Thread starter JeffS
  • Start date Start date
J

JeffS

Hi,

I have a date, lets say 31st May, I would like to know how
to write a query that returns 5 workings days earlier -
24th May, given that working days are Monday to Friday.
Thanking you, Jeff
 
Hi,

I have a date, lets say 31st May, I would like to know how
to write a query that returns 5 workings days earlier -
24th May, given that working days are Monday to Friday.
Thanking you, Jeff
Click to expand...

Would I be correct to assume that only 5 of the 7 days in the week are
working days?
Where DateField between [Enter Date] and [Enter Date]-7

No matter which day of the week is selected, there will be no data for
2 of the previous 7 days.
 
Back
Top