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

arlinsandbulte’s picture

arlinsandbulte commented
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.