Forum Discussion

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? ---...

MarkShnier__You

Qrew Legend

Here is an example of a formula Date Field which will calculate an employees Next anniversary of their hire date. You could just adapt it for your purposes

var date HireDate=[Hire Date];
var date Datetest = Date(Year(Today()),Month($HireDate),Day($HireDate));

IF($DateTest >= Today(), $DateTest, AdjustYear($DateTest,1)

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

AUshYC

Qrew Trainee

18 hours 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
Qrew Legend
17 hours 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
  Qrew Trainee
  17 hours ago
  Thanks so much! :)