Need help with Birthday

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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. 
Photo of Ben Salisbury

Ben Salisbury

  • 132 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
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.