Saturday, December 23, 2017
HowTo Using SharePoint Calculated Columns to Display Current Month List Items
HowTo Using SharePoint Calculated Columns to Display Current Month List Items
Today I was asked by a co-worker to see if I could modify their SharePoint view to only show tasks created in the current month. I knew this option was not previously available as a standard choice but I have not done any SharePoint development in years so I was hoping SharePoint Services 3.0 would have added this feature.
After spending a couple minutes in Edit List it was apparent that it was not available. A quick Google search did not produce any "easy" solutions so I thought Id blog my solution.
My solutions involved creating two computed columns (both calculated columns return Date Only values):
- Created First Day Of Month
=DATE(YEAR([Created]),MONTH([Created]),1) - Created Last Day Of Month
=DATE(YEAR([Created]),MONTH([Created])+1,1)-1
I then added the below filters to view:
Thats it. Basically I create a computed column for the first and last day of the month when the task was created and then filter by todays date being between the two. I found this to be an easy and quick method. Please comment and let me know if there is an easier method.
