Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Filtering data by month or last 30 days

  Asked By: Eliezer    Date: Dec 06    Category: Sharepoint    Views: 32421

I know one can set up a filter in a list or library using the [Today]
parameter. Does anyone know what the parameter would be for filtering
by month? I've tried a number of things, but the best I've been able to
do is use two filter options--greater than the first day of the month
and less than the last day of the month. But I have to go change the
dates every month. What I really want is the current view to show just
the last 30 days worth of entries (which I realize is a slightly
different question). I prefer to use out of the box functionality
rather than get into editing in Designer or Visual Studio. I'm not a
developer and am just not ready to tackle that.



3 Answers Found

Answer #1    Answered By: Trevor Davis     Answered On: Dec 06

Unfortunatly there is no filter  for [Today] - 30 (would be nice) What I
do as a work around is in the list  that you want to filter for 30 Days
create a new column called Filter 30 Days or something like that. Make
this a calculated list. Give the column a simple description, and in the
Fomula box  enter =Created+30 and choose the Date and Time format and
Date Only (I also clear the Add to default view).

Then create a new view  setting up a filter to show  "Filter 30 Days - is
greater than or equal to - [Today]

I hope this helps. If there is a better way please please share.

Answer #2    Answered By: Kristie Hardy     Answered On: Dec 06

What we used to do (I think it still works) is create a column named

Create a calculated column using the Today column in the calculation.

Delete the Today column.

Formula now uses today's date in its calculation.

Answer #3    Answered By: Shayla Mcbride     Answered On: Dec 06

[Today] still works in WSS v3 formulas using this trick. Don't forget to
delete the column after the formula is finished. You'll have to re-add
the column to edit the formula.

You can also use [Me] if you create a temporary Me column.

Didn't find what you were looking for? Find more on Filtering data by month or last 30 days Or get search suggestion and latest updates.