[AccessD] Last Business Day of the Month

[Gary Kjos]

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