Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Function to Filter a list

  Asked By: Jonah    Date: Jun 01    Category: Sharepoint    Views: 2616

I’m creating a view for a list, and I only want items where a datetime metadata column is greater that the current date plus one day.

According to WSS documentation the “TODAY” function should give me the current date, and you can add a day by using the “+” operator.

I tried this syntax, but it doesn’t work (in fact, wss says it’s not a valid function):


Any ideas?

Also, if anyone has some good links (and by “good” I mean, “links with plenty of sample functions” if you know what I mean), please share.



2 Answers Found

Answer #1    Answered By: M Juarez     Answered On: Jun 01

Add a calculated column  that is equal to datetime  metadata - 1. Then
compare this to [today].

Answer #2    Answered By: Marty Mcdowell     Answered On: Jun 01

For a little fun, be aware that you _can_ create a single line of text
field called "today" while you are working on a formula in a complex
calculated field. Put sample  dates into the today column  for various
list items  in your list  to test out your formula. When you are finished
with your formula you can delete the today field and your formula will
change to return values for based upon the current  date. If you want to
edit your formula you will need to temporarily re-add the today column
back into the list.

Didn't find what you were looking for? Find more on Function to Filter a list Or get search suggestion and latest updates.