Skip to main content

Recurring Dates Yearly

  • October 27, 2023
  • 3 replies
  • 29 views

Forum|alt.badge.img+4
  • New Participant

I would like the holidays to be recurring dates yearly. This is to be included in the same table as the leave tracker so that everything is in 1 calendar view only.

3 replies

Databaser
Forum|alt.badge.img+25
  • Brainy
  • October 27, 2023

Isn't that tricky because your end date will vary? Do you want a fixed number of days or a certain day of the week as end date?


Forum|alt.badge.img+4
  • Author
  • New Participant
  • October 30, 2023

Isn't that tricky because your end date will vary? Do you want a fixed number of days or a certain day of the week as end date?


For the holidays, they will all have the same end dates. Is it possible to make them a recurring one?


Databaser
Forum|alt.badge.img+25
  • Brainy
  • October 30, 2023

You could add 2 formula fields to add a year to your current start and end date, and then have an automation that triggers on the update of those fields to create a new record for the next year. 

Formula could be:

IF(TODAY()={Start Date}, DATEADD({Start Date}, 1, "year"))

 Would that be an option?