Forum Discussion

SamUlmer1's avatar
SamUlmer1
Qrew Member
4 years ago

Trying to create Birthday Calendar

I am setting up a personnel directory and wanting to create a Birthday Calendar off of a Calendar Report keying on the date field that lists everyone's birthday.  How can I get it to read only Month and Day so it shows on the calendar.

------------------------------
Sam Ulmer
------------------------------
Formulas and functions
reports and charts

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    np,

    Try this

    var date BirthdayThisYear = Date(Year(Today()), month([DOB]), Day([DOB]));

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

    What that does is to calculate the birthday using the current calendar year. But then if that date has already passed then to advance the birthday to the next year.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------