Date & Time Query

Question

Good Day All,

I have an ORDERS table.

The need is to look @ all orders placed for this year ( Between Jan 1, 2012 and Now() ).

But only between 8pm and 6:30am.

Any ideas on how I could write this?

Thanks for your assistance!

Nigel

---

Thanks! Nigel

Answer 1

It sounds like you need 2 conditions in your Query like:

SELECT ...

FROM [ORDERS]

WHERE ([OrderDate] Between DateSerial(Year(Date()), 1, 1) And Now())

  AND ( (TimeValue([ORDERDATE]) >= #20:00#) Or (TimeValue([ORDERDATE]) <= #06:30#) )

If you don't have any future-dated orders, you can change the Between... condition to simpler Greater Than... condition.

---

Van T. Dinh

Answer 2

Will try it out this week & see if I can get that to work.

---

Thanks! Nigel

Answer 3

Hi Nigel_143,

I think Van's reply is your goal's answer. Do you try it?

T.X.

---

志异征诛，三让两家王朝
功同开辟，一桮万古江南