People
Age
dateBetween(now(), prop("Birthday"), "years")
Next Birthday
if(formatDate(dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years"), "years"), dateAdd(prop("Birthday"), dateBetween(now(), prop("Birthday"), "years") + 1, "years"))
Birthday Today/Tomorrow
if(formatDate(prop("Next Birthday"), "L") == formatDate(now(), "L"), "🎂 Today", if(formatDate(prop("Next Birthday"), "L") == formatDate(dateAdd(now(), 1, "days"), "L"), "🎁 Tomorrow", ""))
Anniversaries
dateBetween(now(), prop("Anniversary"), "years")
Next Anniversary
if(formatDate(dateAdd(prop("Anniversary"), prop("Anniversaries"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Anniversary"), prop("Anniversaries"), "years"), dateAdd(prop("Anniversary"), prop("Anniversaries") + 1, "years"))
Anniversary Today/Tomorrow
if(formatDate(prop("Next Anniversary"), "L") == formatDate(now(), "L"), "💍 Today", if(formatDate(prop("Next Anniversary"), "L") == formatDate(dateAdd(now(), 1, "days"), "L"), "💞 Tomorrow", ""))
Next Birthday (Using Age)
if(formatDate(dateAdd(prop("Birthday"), prop("Age"), "years"), "L") == formatDate(now(), "L"), dateAdd(prop("Birthday"), prop("Age"), "years"), dateAdd(prop("Birthday"), prop("Age") + 1, "years"))
