Forum Discussion

IDOnay's avatar
IDOnay
Copper Contributor
Feb 12, 2024

How to filter SharePoint list view to display peoples having business anniversary today?

hello everyone,

 

How can I filter a SharePoint list view to display contacts with work anniversary today?

  • IDOnay Try this:

    1. Create a date column in list to store the business anniversary
    2. Apply filter on list view based on [TODAY]

    Check: Use filtering to modify a SharePoint view 

     

    If you have past dates in the date column. Try some workarounds given here:

    1. I'm trying to get a person's birthday to show via filtering and calculating fields but it's not working 
    2. How to filter SharePoint list view to display peoples having birthday today? 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • IDOnay's avatar
      IDOnay
      Copper Contributor

      hi ganeshsanap,

       

      Thank you for your return,

       

      I added the [Today] filter function but it is still not filtered, I guess it does not show because it does not match the "year". Is there a different method for this?

       

      Thanks 🙂

       

      • IDOnay 

         

        Check the links given in my above response. It shows how to create a calculated columns based on anniversary date column and filter the list view based on newly created column as workaround to achieve your requirements.

         

        Either of the solutions should work for you.


        Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources