BASES - Birthday Tracker

1 min read

Setup

  • Notes need a birthday property (date type)
  • Filter by tag person where birthday is not empty
  • Works for deadlines, anniversaries, contract renewals

Code

Snippet 1 - fRemainingDays

((number(
  date(today().format("YYYY") + "-" + birthday.format("MM-DD")) +
  if(date(today().format("YYYY") + "-" + birthday.format("MM-DD")) < today(), "1y", "0y")
) - number(today())) / 86400000).round()

Snippet 2 - fAge

if(birthday.format("MM-DD") <= today().format("MM-DD"),
today() - birthday, today() - (birthday + duration("1 year")))

Source