Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Calculate when Easter falls

PeterAP
8 - Asteroid

I'm currently trying to build out a dynamic public holidays calendar for a handful of countries which calculates when public holidays fall each year and what happens if they fall on a Saturday or Sunday. I've managed to add in most of the public holidays, however, I'm struggling to calculate when Easter falls each year in the UK!

 

Does anyone have a sample workflow which can calculate when Easter falls each year?

 

I have some code in our previous analytics tool ACL which calculates it based on the Paschal Full Moon approach - but I'm unable to interpret this to transfer into Alteryx.

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

This workflow hardcodes the days for easter and dynamically find other holidays, but you may be able to leverage some of the logic:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Holiday-and-Date-Data-Set-Builder/td-p... 

Labels