Re: SQL function WEEK_ISO for years beyond 2039

[Arco Simonse <arco400@xxxxxxxxx>]

Hi Rob,

I agree it is better to change to *ISO, but the thing here seems to be that
Ake uses a 2-digit variable with the function. This is an incorrect
combination for years later than 2039.

Regards,
-Arco

Op vr 3 jan. 2025 20:03 schreef Rob Berendt <robertowenberendt@xxxxxxxxx>:

> Arco,
> I still think it is his date format.  He should switch to *ISO.
> I'm at 7.5 with recent PTF's and I changed the spread way out and no
> problems if I use *ISO.  If I use *MDY it goes ill with
> values *week_iso*(*current date* + *69* years + *3* months); *-- returns 13
> with *ISO, +++++ with *MDY*