By Alex Sherwood aka aNotioneer

<aside> 👋 This is a pretty simple formula that's useful if you want to avoid rescheduling recurring events that happen every year / month.

For example if you have a list of birthdays and want to display their date this year.

The formula works whether the date is in the past or the future.

If you have any questions, feel free to add a comment or ask here.

</aside>

Contents:

Birthday this year

Convert a date to the current year

dateAdd(prop("Original birthday"), year(now()) - year(prop("Original birthday")), "years")

Birthdays this year

Payday this month

Convert a date to the current month

dateAdd(prop("Original payday"), month(now()) - month(prop("Original payday")), "months")

Convert a date to the current month & year

This formula is a combination of the current month & current year formulas.

dateAdd( dateAdd(prop("Original payday"), month(now()) - month(prop("Original payday")), "months"), year(now()) - year(prop("Original payday")), "years")

Payday this month