SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
How to modify the view based on these two columns "start date" and "Expire date", I want to show the list item values only between start date and Expire date not the older or future items in the list.
whenever adding a new item it should only show when the current date is between "Start date" and "Expire date".
how to achieve this, is there a way to filter the view or can we customize this javascript.
Thanks in advance
Create a new view, or edit the existing view, and add a Filter.
In the example below, "[Today]" is dynamic built-in variable that represents the current date and time. Note the selection of "AND" and not "OR".
This example would include items where the start date equals today. To be "between" the two dates, change the "is less than or equal to" and "is greater than or equal to" to "is less than" and "is greater than".
In this scenario , you can create a filter by :
Start Date >= [Today] AND End Date <= [Today]
How to view records that fall between 2 date range in sharepoint?
