Forum Discussion

BenSalisbury's avatar
BenSalisbury
Qrew Trainee
8 years ago

Need help with Birthday

We have a Birthday field that is a date field and we would like to show "Birthdays" on a calendar report. Problem is birthdays entered last year don't show on a report because it is showing current year only. What would be the easiest solution to show the birthday on a calendar for every year moving forward. 
Ask about Quickbase functionality
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    This is a countdown until the next birthday (formula duration field), but the variables are what you need:

    var number Age=(Year(Today())-Year([DOB])-1)
    +If(Month(Today())>Month([DOB]),1,0)
    +If(Month(Today())=Month([DOB]) and Day(Today())>=Day([DOB]),1,0);

    var date Birthday=AdjustYear([DOB], $Age+1);

    $Birthday-Today()


    You can pull the Age, Or the next birthday, or the countdown.