Skip to content

Instantly share code, notes, and snippets.

@EmilyRosina
Created March 24, 2024 14:19
Show Gist options
  • Save EmilyRosina/8ffeba14eda69f35dcd3a20691f7a613 to your computer and use it in GitHub Desktop.
Save EmilyRosina/8ffeba14eda69f35dcd3a20691f7a613 to your computer and use it in GitHub Desktop.
Notion: Starsigns from birth dates
lets(
birthMonth, month(prop("Birthday")),
birthDay, date(prop("Birthday")),
ifs(
or((birthMonth == 3 AND birthDay >= 21), (birthMonth == 4 AND birthDay <= 19)), "♈️ Aries",
or((birthMonth == 4 AND birthDay >= 20), (birthMonth == 5 AND birthDay <= 20)), "♉️ Taurus",
or((birthMonth == 5 AND birthDay >= 21), (birthMonth == 6 AND birthDay <= 20)), "♊️ Gemini",
or((birthMonth == 6 AND birthDay >= 21), (birthMonth == 7 AND birthDay <= 22)), "♋️ Cancer",
or((birthMonth == 7 AND birthDay >= 23), (birthMonth == 8 AND birthDay <= 22)), "♌️ Leo",
or((birthMonth == 8 AND birthDay >= 23), (birthMonth == 9 AND birthDay <= 22)), "♍️ Virgo",
or((birthMonth == 9 AND birthDay >= 23), (birthMonth == 10 AND birthDay <= 22)), "♎️ Libra",
or((birthMonth == 10 AND birthDay >= 23), (birthMonth == 11 AND birthDay <= 21)), "♏️ Scorpio",
or((birthMonth == 11 AND birthDay >= 22), (birthMonth == 12 AND birthDay <= 21)), "♐️ Sagittarius",
or((birthMonth == 12 AND birthDay >= 22), (birthMonth == 1 AND birthDay <= 19)), "♑️ Capricorn",
or((birthMonth == 1 AND birthDay >= 20), (birthMonth == 2 AND birthDay <= 18)), "♒️ Aquarius",
or((birthMonth == 2 AND birthDay >= 19), (birthMonth == 3 AND birthDay <= 20)), "♓️ Pisces",
""
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment