[AccessD] Last Business Day of the Month

[James Button]

You did not mention the considerations of:
Bank holidays 
Public holidays
Banking days 
Religious holidays
And local variation of those - as in state and for those wanting to confuse - such things as the different ones in the countries of the UK - 

JimB



-----Original Message-----
From: AccessD <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of Arthur Fuller
Sent: Sunday, April 9, 2023 11:16 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Last Business Day of the Month

LOL. That was me, not the store. Good catch.😀

On Sun, Apr 9, 2023 at 12:49 PM John Colby <jwcolby at gmail.com> wrote:

> Let me comment...
>
> If the wine store is open 465 days of the year, then they are sampling
> their wine too heavily....
>
> On Sat, Apr 8, 2023 at 3:21 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > I think I already know the answer to my question, but thought to ask it
> > anyway. Here in North America the last business day of the month is
> > typically defined as the last Friday of the month in question. How
> > universal is that? Even right here at home, there's a place across the
> > street called The Wine Rack, which is open 465 days a year, and 366 every
> > four years. In that context, LBDOM() would be equivalent to LDOM(), since
> > every day is a business day.
> > . I tMy proposed function would require two parameters, a date,
> defaulting
> > to today, and an int describing the offset from LDOM -- here in Canada,
> my
> > Old Age payments arrive on the third last business day of the month, so
> I'd
> > pass 3 as the second parameter.
> >
> > I'm having a bit of trouble figuring out the best method of allowing the
> > user of said function to specify the local rules. It could be a
> constant; I
> > hesitate ever to monkey with the registry. I certainly don't want to have
> > to pass this as another parameter. But as I stated above, even the wine
> > store across the street has different rules than most of us. Any
> > suggestions?
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com