Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Filtering data by month or last 30 days

Asked By: Eliezer Preston Date: Dec 06, 2007 Category: Sharepoint Views: 1416

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.

Tagged:filtering data by month or last 30 days

3 Answers Found

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

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, 2007

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

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, 2007

[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.