Block - How to set Anniversary Date based on Joining Date

[viti]

Scenario:
Set anniversary date for employee based on joining date. If the anniversary date already passed today set for next year.

1. Add #Joining Date and #Next Anniversary field in the form.

2. Set formula for #Next Anniversary

DateTime(#Today.Year,#Form#JoiningDate.Month,#Form#JoiningDate.Day)

This is to set the Anniversary date as current year date.

3. Add Automation
4. Drag & drop condition block
5. Type #Form#JoiningDate is not None and #Form#NextAnniversary is not None
6. Drag & drop condition block
7. Type #Form#NextAnniversary < #Today

(This condition to check the next anniversary date has been passed today or not)

8. Drag & drop action and choose set block.
9. Variable: Type #Form
10. Expand property and add value
11. Choose ‘Next Anniversary’
12. Type value: #Form#NextAnniversary.AddYears(1)

(This to set next year date as next anniversary if the above anniversary date (based on formula) has been passed today.)

Overview of the block

Result

Date is not passed Today, so the next Anniversay date shows 2023 date.

Date is has been passed Today, so the next Anniversay date shows 2024 date.

Bonus Tips:
You can set notification for the anniversay now!

Related Topic:

Notification - Set Reminder / Due Date Reminder

Do you know you can set up a reminder notification on Inistate? For example, I want to set email reminders based on my project due date. Go to the studio. Due date is a date field. Add notification, When Due Date is due send a notification/alert [screenshot-2022.06.15-14_06_54] Channel: Email. Add a message (optional) Click ‘Advance setting’ (optional) Enable ‘Timing’ (optional) Turn on ‘Before’ - if you want to remind before the due date otherwise system trigger aft…