Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Filter date of 6 months or greater

  Asked By: Chaim    Date: May 20    Category: Sharepoint    Views: 3231

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?



2 Answers Found

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

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

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.