Re: Month Start/Month End

[ken shields <kjs@xxxxxxxxxxx>]

Joel have a question..
        NOW() + 30, +60 or +90 exactly ages receivables by term code , in
        VB or Access
        My /400 aging program, uses a Julian file, but does not take into
account week-ends.The result is a Net30 day customer ends up owing it
inside something like 38 days.(due date )
        The reason I suppose, the week-ends were discounted, was a legal one,
since no business can bill or receive monies on the week-end.
        Perhaps in the past, we were a gentler society.?
        I've asked several accountants, but have not gotten any satisfacory
        answer
        Anyone have an idea?...maybe someone with legal training....LOL
Ken Shields.
Joel Fritz wrote:
>
> I was on call the week of 1/1/01.  We had a program that used the Julian
> date to check the (3 days in the future max) date entered by the operator.
> Apparently it had run for ten years or so without the future date being in
> the next year.  That was the closest I came to having to fix a Y2K bug in
> the middle of the night that week.
>
> > -----Original Message-----
> > From: Leif Svalgaard [mailto:leif@leif.org]
> > Sent: Thursday, February 21, 2002 2:06 PM
> > To: midrange-l@midrange.com
> > Subject: Re: Month Start/Month End
> >
> >
> > > From: Chris Whisonant <chris.whisonant@comporium.com>
> > > > Just a thought, but could you CVTDAT from (say) *SYSVAL
> > format (02212002)
> > > to *JUL (yyddd), add 1 to the *JUL date, then CVTDAT back
> > from *JUL to
> > > *SYSVAL, then see if the "dd" position = "01". If so, then
> > the date is the
> > last day
> > > > of the month.
> > > >
> > > > Haven't tried it, but it's worth a shot.
> > >
> > > no, it would just compute tomorrow's date and may even
> > complain on 12/31.
> > >
> >
> > of course, if it is today you are checking then it would
> > work, except for
> > at the end of the year where you may get and error, but you
> > might monitor
> > for that...
> >
> >
> >
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.

--
Best Regards
Ken Shields
Home phone: 905 404-2062
Bus  phone  905 725-1144 (326)