I see that I forgot to reply all in my reply, so I'm forwarding the thread with Stan's latest reply.
---------- Forwarded message --------- From: Stan Brown (using GC 4.14) <[email protected]> Date: Tue, Oct 31, 2023 at 5:32 PM Subject: Re: [GNC] Scheduled Transactions: Monday before the 4th Wednesday To: R Losey <[email protected]> I never thought about it that way, but as soon as you point it out it's obvious: the Monday that falls between the 20th and 26th of the month, inclusive. That's relatively easy to compute, but like you I've never seen any out-of-the-box software do it. (In Excel it's doable with formulas, but there's no predefined function for it.) I suppose I can just manually change the date in the SX every month. Or for that matter, it's one transaction a month, and my bank texts me when it comes in, so I could just enter it as a regular transaction. Neither is ideal, but as I said earlier the inconvenience is minor. Stan Brown Tehachapi, CA, USA https://BrownMath.com > On Tue, Oct 31, 2023 at 2:32 PM Stan Brown (using GC 4.14) > <[email protected] <mailto:stan%[email protected]>> wrote: > > Every month, I get a direct deposit two days before the fourth Wednesday > of the month. That's not the same as the third Monday. ...> > I have scheduled my transaction for the 4th Wednesday of each month, but > to be created two days early. Then when the transaction fires, I > manually change the date the Wednesday. > ... is there any way to have the transaction appear on the right > day (two days before the fourth Wednesday) and with that Monday date, > not the Wednesday date? On 2023-10-31 15:17, R Losey wrote: > I know the solution to this problem, but I've never seen any software > that has enabled such an algorithm. It's a pretty simple solution, but > it hasn't been implemented anywhere that I know of. > > The earliest the 4th Wed could be is the 22, and the latest in the > 28th... so, the Monday before the fourth Wed is a Monday when the date > is between the 20th and 26th of any month. > > It's like US election days, which are the first Tue following the first > Mon, which means "the Tue between the 2nd and the 8th". > > This algorithm will work for any rule like this. ... -- _________________________________ Richard Losey [email protected] Micah 6:8 _______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
