Birthday from Day & Month

Calculate someone’s next birthday using day and month numbers.

Next Birthday

lets(
	day, ifs(prop("Day") < 10, "0") + prop("Day"),
	month, ifs(prop("Month") < 10, "0") + prop("Month"),
	date, ifs(day && month, [now().year(), month, day].join("")),
	if(
		date >= now().formatDate("YYYYMMDD"),
		date.parseDate(),
		date.parseDate().dateAdd(1, "year")
	)
)