Forum Discussion

KeithHendrick's avatar
KeithHendrick
Qrew Member
3 years ago

Reminder Notification for Upcoming Birthdays

We want to know when an employee's birthday is upcoming.  We capture their DOB in a date field, so how do I get that month/day information in a format that I can use in a Reminder notification? ---...
AUshYC's avatar
AUshYC
Qrew Trainee
2 months ago

Hi All, 

Thanks for explaining how to do this! I've attempted to copy the formula you've shared to get my birthdays in a month/day format. I keep getting a syntax error reporting a missing parentheses bracket. Here's what I have for my formula. Would you happen to have any idea what I'm doing incorrectly? 

var date Birthday=[Date of Birth];
var date Datetest = Date(Year(Today()),Month([Date of Birth]),Day([Date of Birth])
IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1))

 

Thanks in advance! :)

-Abby 

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months ago

try this fix.  needs an extra closing ) at the end of the 2nd line.

 

var date Birthday=[Date of Birth];
var date Datetest = Date(Year(Today()),Month([Date of Birth]),Day([Date of Birth]))
IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1))

  • AUshYC's avatar
    AUshYC
    Qrew Trainee
    2 months ago

    Thanks so much! :)