Forum Discussion

6 Replies

    • Norman Young's avatar
      Norman Young
      MVP
      Apr 04, 2019

       

      Hello shobhitbhalla & Maggan Wåhlin,

       

      Interesting question and response. If the column stores the birthday for the current year the filtered view based on "Today" makes sense.

       

      shobhitbhalla are you storing date of birth in the list or are you calculating the current year birth date?  If you are storing date of birth I don't see how the "Today" filter will work. If you are storing the current year birth date can you please share the approach/code you used to achieve this?

       

      Thanks.

       

      Norm

       

      • shobhitbhalla's avatar
        shobhitbhalla
        Brass Contributor
        Apr 05, 2019

        I have stored list of birthdays in SharePoint list when I compare with the [Today] function it compare with dd-MM-yyyy. To find out current day birthday I need to compare dd-MM only. I have tried to work with calculated field to separate dd : day[DOB] and mm : month[DOB] parts in two column. But still view filter on these column are not working.

        Norman Young Maggan Wåhlin 

         

Resources