Discussions

Expand all | Collapse all

Need help with Birthday

  • 1.  Need help with Birthday

    Posted 10-02-2017 15:39
    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. 


  • 2.  RE: Need help with Birthday

    Top
    Contributor
    Posted 10-02-2017 15:53
    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.