Displaying Contents/Items from Current Month in SharePoint List

Question

Hello,
I would like to display only the contents/items from the current month in a SharePoint list. For example, if it's April, I want to see only the contents/items tagged with the month of April. Is this possible? If yes, what do I need to do?

It should do this automatically.

Thank you!

Answer 1

Hi @Martin, Heidi (SE GP T SP PS) ,

Thank you for posting in this community.

You can create two calculated columns to get the start date and end date of the month of the date column(you said to store April's date column). Then check if the start date of the month of the date value is less than or equal to the current date [Today] and end date of the month of the date column is greater than or equal to the current date [Today]. If yes, it is in the current month.

Create two calculated columns named "Start of Month" and "End of Month". Return as the Date and Time data type.

"Start of Month" =DATE(YEAR([date]), MONTH([date]), 1)

"End of Month" =DATE(YEAR([date]), MONTH([date])+1,1)-1

Create/modify a view and add filter as follow: enter image description here

This allows the view to automatically display the current month's item.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Martin, Heidi (SE GP T SP PS) ,

Sure, my pleasre.

Here are detail steps:

1.You have your own stored time column containing the month (in my case, “date”).

2.You can create two calculated columns:"Start of Month","End of Month".

Use the following corresponding formulas:

"Start of Month":

=DATE(YEAR([date]), MONTH([date]), 1) 

"End of Month":

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

3.Create/modify a view and add filter as follow: enter image description here.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Good morning, @Xyza Xue_MSFT

Thank you very much for your feedback.

I have a small problem. I don't know exactly what columns I need to have or create and in which columns I need to store which calculation. Can you describe this in more detail? That would be great! Thank you so much.

Answer 4

Good morning Haoyan Xue_MSFT,

Thank you so much! :-) It works!!!

BR,
Heidi

Answer 5

Hi @Xyza Xue_MSFT

In my case:

I want to create the column for month.

One month are calculate from 26/Aug/2024 to 25/Sep/2024 ==> is September month.

kindly give me advice for this case!!

Best Regards!

Tri