[GNC] Fwd: Scheduled Transactions: Monday before the 4th Wednesday

[R Losey]

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) <stan+gc at fastmail.fm>
Date: Tue, Oct 31, 2023 at 5:32 PM
Subject: Re: [GNC] Scheduled Transactions: Monday before the 4th Wednesday
To: R Losey <rlosey at gmail.com>


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)
> <stan+gc at fastmail.fm <mailto:stan%2Bgc at fastmail.fm>> 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
rlosey at gmail.com
Micah 6:8