Using Sharepoint Calculated Columns to Display Current Month List Items

How To: Using SharePoint Calculated Columns to Display Current Month List Items

1. create two computed columns (both calculated columns return Date Only values):

      a. Created First Day Of Month

            i. =DATE(YEAR([Created]),MONTH([Created]),1)

      b. Created Last Day Of Month

            i. =DATE(YEAR([Created]),MONTH([Created])+1,1)-1

I then added the below filters to view:

Leave a Reply