0

I want to display birthdays this month from list items.

I have a form where we add birthdays manual. This just for Jubilee birthdays (50/65, big thing in Sweden)

Since there is a lot of hits when googling this problem and no solution that works.

But from some guides I tried to compare columns with no luck.

From birthday date I have a calculated column that takes out month (MMMMM) so i get "november" in an Single line output.

I have done the same with todays Date and there i got the same calculated that gives me month in a Single line output.

Then i make a 3rd calculated column and tries

This is what i tried `=EXACT([Column1],[Column2])` 

I have tried diffrent versions of this with IF and "yes,"no" with no luck.

The formula contains a syntax error or is not supported.

It can not be this hard too display birthdays from a specific month. I can not add webparts either.

Solution is posted below

  • Did you try ; instead of , in =EXACT([Column1],[Column2])? It depends what your regional settings are, so someone has , instead of ; and the others have opposite. – Danilo Nov 21 '17 at 14:18
  • Life saver! It worked and the solution works perfect. – Mathias F Nov 22 '17 at 6:56
  • I will add it as solution in answer so others can also know it works. – Danilo Nov 22 '17 at 7:25
  • I added a solution with all my steps. I think i got it right. I am just glad it is working. I tried alot of diffrent solutions that could be found online. None of them worked. This takes a bit of work but it works fine. Now i just want it to collect the data from the active directory DB but that is a task for the future. – Mathias F Nov 22 '17 at 9:19
  • --edit I realized that my work was not correct. I looked to be working but when i used "Todays date" with in a list it is not updated with the actual date of "Today" but the date when the list entry was saved. I guess i have to use JS to look up the birthday month and then check todays month. Then view the list with CQWP and read a html file maybe that utilize the list and JS and maybe css to do the list nice. But i want this to work without this. Seems impossible to get the current month from calculated. – Mathias F Nov 22 '17 at 11:10
1

Try ; instead of , in =EXACT([Column1],[Column2]). So it will work as
=EXACT([Column1];[Column2])

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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