Skip to main content
Question

Need help with Birthday

  • October 2, 2017
  • 0 replies
  • 29 views
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. 
    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • October 2, 2017
    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.
    Terms & ConditionsAccessibility statement