Re: SQL function WEEK_ISO for years beyond 2039

[Brad Stone <bvstone@xxxxxxxxx>]

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.