Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Filter date of 6 months or greater

Asked By: Chaim Odom Date: May 20, 2006 Category: Sharepoint Views: 465

I want to filter a list for items not modified in the past 6 months.
However, [Today], is the only variable I see that I can pass it for a
date. What I really want is to filter by things equal to or greater
than [Today-6 months]. Of course this is not a valid variable. Does
anyone know what other variables are available for filtering or what
custom code is needed to do this?

Tagged:filter date of months or greater

2 Answers Found

Answer #1 Answered By: Damon Garner Answered On: May 20, 2006

I believe the solution is to calculate the expiration date using the
created date. This means that the expiration date is calculated when
the item is created, not the other way around where you try to
calculate whether the item should be expired as of today.

Answer #2 Answered By: Freddy Heath Answered On: May 20, 2006

I guess I just was not thinking out of the box. That worked
like a charm with a computed column.

Didn't find what you were looking for? Find more on Filter date of 6 months or greater Or get search suggestion and latest updates.