How to filter a view by Date & Time
Ihave a custom view which is supposed to check that the Start Date is greater than or equal to[Today].But[Today] does notcheck the Date + Time!! Why not? I find it very hard to believe that this is by design, how can they leave out such abasic feature. Seriously!I tried using [Now] but its not allowed.How can i filter my view by Date + Time?I'm using Sharepoint 2007.
July 29th, 2009 11:29pm
I think that you can try the workaround by creating your custom view as a datasheet view instead of a standard view if you dont want to customize. Modify the custom filter on the datetime column header a little bit every time you review the data. Actually, you just need to modify the datetime based on your selection, and don't have to remember the format to input date time string every time, so, it won't be too difficult to use.Please let me know if you have difficulty with the datasheet view or you want to discuss about the detail of customization.
July 31st, 2009 8:07am
This wont work. The underlying problem is that [Today] only returns the date portion of the date. And my custom Start Date column returns the Date + Time.So for example,Start Date is greater than or equal to[Today] will always fail because:[Today] = 40,024 (Serial date value)[Start Date] = 40, 024.604166667 (Serial date + time value)Any ideas?
August 2nd, 2009 10:22pm
Any solution yet?
September 24th, 2009 11:02am
You can edit the view in the sharepoint desiginer and add the attribute IncludeTimeValue="True" to all Date columnsNot ideal, but at least it works for me.More info here: http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/
September 24th, 2009 11:42am
Please check link http://blogs.msdn.com/sharepointdesigner/archive/2008/02/25/filtering-and-formatting-with-date-values.aspx Regards, GonçaloGonalo
April 22nd, 2010 10:30am
gsardinha: Pleased do not propose your own posts as answers. It's not helpful. Propose the good answers of other people. Wait for someone else to propose your posts. (Moderator)2010 Books: SPF 2010; SPS 2010; SPD 2010; InfoPath 2010; Workflow etc. 2007 Books: WSS 3.0; MOSS 2007; SPD 2007; InfoPath 2007; PerformancePoint; SSRS; Workflow Both lists also include books in French; German; Spanish with even more languages in the 2007 list.
June 10th, 2010 4:31am
Here is the solution http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/
July 4th, 2012 4:33am