Query time range

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;
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14000-query-time-range.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000

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


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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;

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
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)



wrote in message
news:1153946144.151558.186920@b28g2000cwb.googlegr oups.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
> 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.
>

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
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)



wrote in message
news:1153946144.151558.186920@b28g2000cwb.googlegr oups.com...
> 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.
>



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Look to the experts for your answers:
http://www.mvps.org/access/datetime/index.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000

jmonty


"stillwalkingaway@gmail.com" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
> 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.
>
>

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
Thanks do much for all your help!

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14000
Thanks so much for all your help!