Requirement: Filter SharePoint View to display items with Due Date in 6 months from Today.
Solution:
1) Create a calculated column,"DueDateFor6Months" of type Date and Time, with the following Formula:
=DATE(YEAR([Due Date]),MONTH([Due Date])-6,DAY([Due Date]))
2) Edit the SharePoint View and apply the following Filter:
Show the Items when column,
"DueDateFor6Months" is less than or equal to "[Today]".
No comments:
Post a Comment