Query time range

[stillwalkingaway]

hi. i was wondering how i would set a time range so that the
DBatch.start field will display a range from 6PM yesterday or
tuesday(any weekday) to 5:59PM the next day i.e. today/wednesday.
Here's what i have:

SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end,
DBatch.duration, DBatch.recordcount
FROM DBatch
WHERE ????
ORDER BY DBatch.start;

Both the DBatch.start and the DBatch.end fields are in the Date/Time
format.
Thanks.

 

[Pieter Wijnen]

if you don't mind next /or previous day to be a holiday, saturday or sunday
SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end,
DBatch.duration, DBatch.recordcount
FROM DBatch
WHERE DBatch.start >= Date() -1 + 18/24
AND DBatch.start < Date() + 18/24
ORDER BY DBatch.start;

else you'll have to use some calculations in addition
If I'm not mistaken Allen Browne has some excellent code to use to discount
Sa,Su & holidays

HTH

Pieter

And I'm aware 18/24 equals 3/4 equals 0.75 - but it's more understandable
(if not as fast) <g>

 

[Pieter Wijnen]

if you don't mind next /or previous day to be a holiday, saturday or sunday
SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end,
DBatch.duration, DBatch.recordcount
FROM DBatch
WHERE DBatch.start >= Date() -1 + 18/24
AND DBatch.start < Date() + 18/24
ORDER BY DBatch.start;

else you'll have to use some calculations in addition
If I'm not mistaken Allen Browne has some excellent code to use to discount
Sa,Su & holidays

HTH

Pieter

And I'm aware 18/24 equals 3/4 equals 0.75 - but it's more understandable
(if not as fast) <g>

hi. i was wondering how i would set a time range so that the
DBatch.start field will display a range from 6PM yesterday or
tuesday(any weekday) to 5:59PM the next day i.e. today/wednesday.
Here's what i have:

SELECT DBatch.batchname, DBatch.start AS StartTime, DBatch.end,
DBatch.duration, DBatch.recordcount
FROM DBatch
WHERE ????
ORDER BY DBatch.start;

Both the DBatch.start and the DBatch.end fields are in the Date/Time
format.
Thanks.

--

 

[Guest]

Look to the experts for your answers:
http://www.mvps.org/access/datetime/index.html

jmonty

 

[adamantium]

Thanks do much for all your help!

 

[adamantium]

Thanks so much for all your help!