I would like to create a list view that filters out items with 'Date Joined' in the the current month/year.

I have created two calculated columns - StartOfMonth and EndOfMonth

StartOfMonth = DATE(YEAR(Created),MONTH(Created),1)

EndOfMonth= DATE(YEAR(Created),MONTH(Created)+1,1)-1

I am not able to save the view with the filters. Can anyone advise what the issue is?

enter image description here

  • What is your calculated column Return data type?
    – Pradip R.
    Jun 28, 2023 at 9:12
  • @Pradip R. Date and Time
    – soh
    Jun 28, 2023 at 9:17
  • Check if this solution works in your case blog.pentalogic.net/2009/11/…
    – Pradip R.
    Jun 28, 2023 at 9:21
  • 1
    @Pradip R. Yes, it works. Thank you!
    – soh
    Jun 28, 2023 at 9:28
  • I have provided a solution to this issue in the form of an answer. I kindly request that you mark it as the accepted answer so that others can benefit from this solution as well.
    – Pradip R.
    Jun 28, 2023 at 9:36

1 Answer 1


In summary from the comment,

Your two calculated formulas as follows:

StartOfMonth = DATE(YEAR([DateJoined]), MONTH([DateJoined]), 1)

EndOfMonth = DATE(YEAR([DateJoined]), MONTH([DateJoined]) + 1, 1) - 1

Next, create a new view, such as "Joinee This Month," and set up the following filter:

StartOfMonth is less than or equal to [Today]


EndofMonth is greater than or equal to [Today]

For more detailed instructions, you can refer to the original article at this link: http://blog.pentalogic.net/2009/11/howto-filter-items-current-calendar-month-view-sharepoint/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.