I didn't realize that Good Friday could have a formula to calculate. I thought it was almost arbitrarily set by the Catholic Church / Vatican. Only after reading this thread I googled to find that it is based on the lunar calendar.
So I do not have an answer to how it could be done but I would like to complicate things a little. The Eastern and Western churches calculate it a little differently from each other, one follows the Julian Calendar while the other follows the Gregorian Calendar. Have fun :-) Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Monday, September 23, 2013 4:35 PM To: [email protected] Subject: Re: Business Time Segment for Good Friday I had a little bit of time after lunch, so I got the Month Calculation mostly correct I think. I got the day mostly working, but it's not quite ready yet. Basically I created a field on a form called Year, and when a user enters the value into that Field, then clicks a button, I do a Set Fields in an Active Link to set the Month field to: 3 + (((((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (1 - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (29 / (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) + 1)) * ((21 - ($Year$ - 19 * ($Year$ / 19))) / 11))) - (($Year$ + $Year$ / 4 + (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (1 - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (29 / (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) + 1)) * ((21 - ($Year$ - 19 * ($Year$ / 19))) / 11))) + 2 - ($Year$ / 100) + ($Year$ / 100) / 4) - 7 * (($Year$ + $Year$ / 4 + (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (1 - (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) / 28) * (29 / (((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) - 30 * ((($Year$ / 100) - ($Year$ / 100) / 4 - (($Year$ / 100) - ((($Year$ / 100) - 17) / 25)) / 3 + 19 * ($Year$ - 19 * ($Year$ / 19)) + 15) / 30)) + 1)) * ((21 - ($Year$ - 19 * ($Year$ / 19))) / 11))) + 2 - ($Year$ / 100) + ($Year$ / 100) / 4) / 7))) + 40) / 44 I realize that it would be more user friendly to calculate it in pieces, but it's more amusing to me to do it in one big calculation. The reason I don't have the day of the month working correctly yet is because it's much larger than this, using the month (this entire calculation) inside of the other calculation. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brian Goralczyk Sent: Monday, September 23, 2013 11:12 AM To: [email protected] Subject: Re: Business Time Segment for Good Friday ** Shawn, As I am prone to building technology for everything take it to heart when I say, I would just add the records. It probably isn't worth the effort unless you want bragging rights. Brian Goralczyk Brian Goralczyk Phone 574-643-1144 Email [email protected] On Mon, Sep 23, 2013 at 12:01 PM, Pierson, Shawn <[email protected]> wrote: ** Good morning, So maybe I shouldn't be sticking my nose into something that looks extremely complex considering all the other work on my plate, but does anyone have a good way to calculate Good Friday in a Business Time segment? Sure, I can manually create the dates for several years into the future, but all the calculates for it I've seen on Google seem overly complicated in a way that wouldn't work with Business Time. Starting last year, it became a company Holiday so I'd like to add it to the list in Remedy. It would only take me about five minutes to enter the next ten years' worth manually as individual records, so I won't spend the time creating workflow that uses a SQL function (readily available on Google) tied to an Escalation that could automatically create the records for me. Thanks, Shawn Pierson Remedy Developer | Energy Transfer Private and confidential as detailed here <http://www.energytransfer.com/mail_disclaimer.aspx> . If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here <http://www.energytransfer.com/mail_disclaimer.aspx> . If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
