Help

Next year's anniversary where this years is based on a formula

Topic Labels: Formulas
Solved
Jump to Solution
1311 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Brite_Admin
7 - App Architect
7 - App Architect

I have a marriage date for some people and no date for others. I created a field called THIS YEARS ANNIVERSARY as shown below.
IF({Marriage Date},DATETIME_PARSE(
DATETIME_FORMAT(
{Marriage Date},
‘MMMM D’
)&
’ '&
YEAR(
TODAY()
),
‘MMM D YYYY’
))

I need a formula for NEXT year’s anniversary. If THIS YEARS ANNIVERSARY was a simple date field, I know how to use the DATE_Add formula but I am struggling with how to use the DATE Add formula to this formula field so it is also seen as a date so I can use it as a date field in a calendar.

Any help would be appreciated.

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

Your current formula creates a valid datetime, so you can use DATEADD() in another field to add one year for next year’s anniversary.

Another option would be to modify the formula above to automatically shift to show next year’s anniversary once the current year’s anniversary has passed.

See Solution in Thread

3 Replies 3
Justin_Barrett
18 - Pluto
18 - Pluto

Your current formula creates a valid datetime, so you can use DATEADD() in another field to add one year for next year’s anniversary.

Another option would be to modify the formula above to automatically shift to show next year’s anniversary once the current year’s anniversary has passed.

Williams_Innova
7 - App Architect
7 - App Architect

I have to echo @Justin_Barrett’s comment here. I like the option to set it up where it adjusts to the next year once the anniversary has passed. I did something something very similar for birthdays and it worked great! It was pretty much a birthday countdown calendar for people I worked with.

Chris

Brite_Admin
7 - App Architect
7 - App Architect

That’s what I ended up doing and it works great. Thanks to everyone.