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.