Re: SQL function WEEK_ISO for years beyond 2039

[Brad Stone <bvstone@xxxxxxxxx>]

sorry, I meant "the old y2k quick fix" not "only"

On Fri, Jan 3, 2025 at 12:51 PM Brad Stone <bvstone@xxxxxxxxx> wrote:

> Ah.. the only y2k quick fix is coming to bite folks just like I
> predicted.  :)
>
> On Fri, Jan 3, 2025 at 12:43 PM <konsult@xxxxxxxxxxxxxxx> wrote:
>
> > Modernizing program that creates/updates the calendar file for a client
> > and
> > many planning functions are based on week number.
> >
> >
> >
> > I want to use the SQL "week_iso" function and found that it works pretty
> > well for the next 10 to 15 years.
> >
> >
> >
> > I have as input a date field (*ISO) format and expect a zoned two digit
> > value in response.
> >
> >
> >
> > As follows:
> >
> > "exec sql set :weeknum = week_iso(:datum);"
> >
> >
> >
> > The problem occurs when generation data further on in the future like
> > dates
> > in the year 2040 and beyond. Then I get a RNQ0114 error with text
> > indication
> > that year cannot be beyond 2039.
> >
> >
> >
> > I have been searching for a workaround but have yet to find one.
> >
> >
> >
> > /Ake Olsson/
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.