How to filter or compare SharePoint Calendar Events by time

Hi,
This is in regards to SharePoint Calendars and filtering.

Say you have an Event at 8AM to 12PM, I want a filter that will show this Event IF the CURRENT TIME is within 8AM to 12PM.   Essentially I want to create a list that will show events that are happening this very moment.

You'd think you could compare the start time or end time with [today] but while [today] will give you the current day, it does NOT drill down to the specific time.   Trying to use [today] will cause all events of that day to show up.  Perhaps what I'm looking for is a [now] but of course there is no such function.

I'm researching content editor web parts and seeing if I can filter views with java script but I don't know if I'll be running to a dead end.  

The question is.... is what I'm looking for possible??? or am I heading into a dead end, in which case I can stop looking.

Thanks.


Philx1234567Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RajneshwarPrasadCommented:
If you using MOSS you can use TIME(hour,minute,second) function just like you have done for TODAY.
Philx1234567Author Commented:
I am using MOSS.

Time(hour,minute,second) "Returns the decimal number for a particular time." implying that I have to enter a particular time for that function.   I don't want to enter anything, I want a function that will return the current date & time.

[today] will fill in the current date for you as a point of comparison.   So I can compare [today] with  4/1/2010 for example.   I can see if [today] is before or after 4/1/2010.  

I want a [now] so to speak.   A point of comparision that is specific to the TIME of day.   If I use [now] it would give me the current date and the current TIME of it being called.
irinucCommented:
Hi,
there is no out of the box function that can provide this information.
I found 2 links that may provide some ideas for workarounds.
This one provides an idea on using javascript to hide rows that do not contain today
http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/d7be2bea-bab9-43a8-a7f6-b934f3b529bf
I believe you can take this further, if you use the javascript getTime() function and combine it with soma calculated columns that contain the start hour and end hour, using HOUR(column).

Another interesting idea is the one that this page presents:
https://www.hasustorm.com/books/English/John.Wiley.And.Sons.Ajax.Bible.Apr.2007.chm/final/BBL0134.html

I have to say that I haven't tried them, so I do not know if they work.
I only used getTime to display today date and hour at page loading.

Hope this give you some ideas.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Philx1234567Author Commented:
Thanks for responding.   This has been passed to someone else to try to figure out so personally I'm done with this yay.
Philx1234567Author Commented:
Best answer possible without giving code.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.