[AccessD] Last Business Day of the Month

[Gary Kjos]

I may have been mistaken on the "Week started on Monday" thing.  Good
for me I am forgetting BS I don't really need.

But here is info on the 4-5-4 retail calendar...

https://www.retaildogma.com/retail-calendar/

GK

On Sat, Apr 8, 2023 at 2:42 PM Gary Kjos <garykjos at gmail.com> wrote:
>
> The retail companies I worked for used a Fiscal 454 calendar that
> started in February. Fiscal February, April,  May, July, August,
> September, November and January had 4 weeks and March, June, October
> and December had 5 weeks every year Excepting for an occasional year
> that had an extra week in January to realign things.  This was done to
> better compare month to month this year verses previous years. To
> handle reporting we used a "Date Table" that set what fiscal month
> each date belonged to. I believe that their weeks started on MONDAY
> and ended on SUNDAY as well as weekends were much bigger sales days
> than week days.
>
> GK
>
> On Sat, Apr 8, 2023 at 2: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
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com



-- 
Gary Kjos
garykjos at gmail.com