Download & Extend

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

Project:Date
Version:6.x-2.4
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:closed (won't fix)

Issue Summary

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.

Comments

#1

Component:Date CCK Field» Code
Status:active» closed (won't fix)

Hi,
I am just indiscriminately closing all support requests with no activity for more than 1 year.
If you consider this to still be a valid issue / support request, feel free to re-open.
BUT,
if you are re-opening this issue, please provide specific details on how this issue can move forward.

Thanks.

nobody click here