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.

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.

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?

Any solution yet?

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/

Please check link http://blogs.msdn.com/sharepointdesigner/archive/2008/02/25/filtering-and-formatting-with-date-values.aspx Regards, GonçaloGonalo

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.

Here is the solution http://nickgrattan.wordpress.com/2008/04/24/filtering-views-by-time-and-date/