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]<mailto:[email protected]> On Mon, Sep 23, 2013 at 12:01 PM, Pierson, Shawn <[email protected]<mailto:[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 the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
