BirthDay calculated column on sharepoint

Question

Ive been working on a list in sharepoint and i want to know if today there are birthdays. So i created a calculated column using a born date.

I can know if the actual month is equal to the born month and if the actual day is equal to the born day, but i cant know both. I dont know why.

These code sentences works for me:

=DAY(TODAY())=DAY([Fecha Nacimiento])
=MONTH(TODAY())=MONTH([Fecha Nacimiento])

i need something like this but it doesnt works:

=AND(DAY(TODAY())=DAY([Fecha Nacimiento]), MONTH(TODAY())=MONTH([Fecha Nacimiento]))

This is the error that i got:

The security validation of this page has timed out. Click Back in your web browser, refresh the page, and try the operation again.

What's supposed that i have to do?

Thank you!!

score 0 · Answer 1 · answered Feb 04 '21 at 01:58

0

Per my test, your formula works on my end. I did not get the error like yours.

Besides, you could try to use NOW() instead of TODAY() , check if that works for you.

=AND(DAY(NOW())=DAY([Fecha Nacimiento]), MONTH(NOW())=MONTH([Fecha Nacimiento]))

answered Feb 04 '21 at 01:58

Michael Han

Thanks for your answer!!! It doesnt works for me yet. I got this error : > The formula contains a syntax error or is not supported. – Yeison Stiven Builes Uribe Feb 04 '21 at 14:04

1 Answers1