How to filter by relative hour period NOT starting and ending on the same day?

flaviovs - November 8, 2009 - 03:36
Project:Date
Version:6.x-2.4
Component:Date CCK Field
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

It may be a dumb question, and in fact it looks like so dumb to me. But I'm scratching my head for days looking for a solution to this, but had no progress.

Well, I have a CCK field called "Day" which stores the date an event will occur, with day granularity.

All I want to do is show all events that will occur between the 10pm of the day before the event, to the 9:59pm of the day of the event.

So if I have an event with Day = "2009-11-08", then the event should be listed if current date/time is between "2009-11-07 10pm" and "2009-11-08 9:59pm".

An event with Day = "2009-12-01" should be listed if current time is between "2009-11-30 10pm" and "2009-12-01 9:59pm".

And so on...

Can anyone please tell me how do I do this?

Thanks in advance.

 
 

Drupal is a registered trademark of Dries Buytaert.