Oct 26, 2023 09:41 PM
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.
Oct 27, 2023 01:22 AM
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?
Oct 29, 2023 07:20 PM
For the holidays, they will all have the same end dates. Is it possible to make them a recurring one?
Oct 30, 2023 04:33 AM
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?