View (Filter by last hour)
- Does anyone know how to do this? I've created a new calculated field called DatePlusHour, to get my created Date+1 hour. (=Data+0,0416666666666667) Yeah, I know its bad code, but i couldnt do it other way.
Now that I have this, I can't make my view to filter DatePlusHour >= Today, because Today doesn't return current Time. Just Day+00:00:00.
Any suggestions? Thanx in advance.
- Mad-tie
Answers
CAM supports the IncludeTimeValue attribute that allows "Today" to return date and time. However, this cannot be set using the SharePoint UI. Instead, you need to manually edit the CAML query associated with the view filter with SharePoint designer.
I've blogged how to do this here: http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/
HTH, Regards,
Nick Grattan.
____
Web: http://www.nickgrattan.net
Blog: http://nickgrattan.wordpress.com
All Replies
Hi,
Can you please elaborate what you are trying to achieve?
Regards,
shridha
CAM supports the IncludeTimeValue attribute that allows "Today" to return date and time. However, this cannot be set using the SharePoint UI. Instead, you need to manually edit the CAML query associated with the view filter with SharePoint designer.
I've blogged how to do this here: http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/
HTH, Regards,
Nick Grattan.
____
Web: http://www.nickgrattan.net
Blog: http://nickgrattan.wordpress.com
Nick Grattan wrote: CAM supports the IncludeTimeValue attribute that allows "Today" to return date and time. However, this cannot be set using the SharePoint UI. Instead, you need to manually edit the CAML query associated with the view filter with SharePoint designer.
I've blogged how to do this here: http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/
HTH, Regards,
Nick Grattan.
____
Web: http://www.nickgrattan.net
Blog: http://nickgrattan.wordpress.com
Thanx man! You've just saved my life! =) But why isnt this a standard feature? I'm not the only one tryin to achieve this! Or am I? =)
Farewell & Good Luck with Everything!
Take care,
- mad-tie
Thanks a lot Nick Grattan, I took your lesson
Mad-tie, so many stuff in sharepoint (wss) are standard and it allready do a lot! It's one of my favorite applications. But to do some more tweaked configurations you need to lower the level of integration using tools like Sharepoint Designer, community tools (allways search at codeplex) or directly modifing the files.
Best Regards,
Pedro Marques
