RE: [EXTERNAL] Re: SQL function WEEK_ISO for years beyond 2039

Yes, that works for me.

Brian Neifert
IT Manager, ERP systems

Oldcastle BuildingEnvelope®
One Seagate
Suite 1630
Toledo, OH 43604

Mobile +1 (419) 215-6284
Email bneifert@xxxxxxx<mailto:bneifert@xxxxxxx>
www.obe.com<http://www.obe.com/>

From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Marco Facchinetti
Sent: Thursday, January 9, 2025 10:20 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: SQL function WEEK_ISO for years beyond 2039

CAUTION: This email originated outside of the organization. Do not click links or open attachments unless you are expecting this email and know the contents are safe.

Bottom line - convert to 8-digit dates or true date types.

Best regards
--
Marco Facchinetti

Mr S.r.l.

Tel. 035 962885
Cel. 393 9620498

Skype: facchinettimarco


Il giorno dom 5 gen 2025 alle ore 18:50 Vern Hamberg via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> ha scritto:

Well, 1939 and before wasn't available in the setup where 100-year
window went from 1940 to 2039, so I see nothing changes for that when
using 2-digit years. Year 39 has always been 2039 and will still be
under the 1970 window.

Bottom line - convert to 8-digit dates or true date types.

Cheers
Vern

On 1/3/2025 3:27 PM, Glenn Ericson wrote:

What happens to 1939 and further back?

Sent from my iPhone

Glenn Ericson

On Jan 3, 2025, at 2:41 PM, Dan Bale <dan.bale@xxxxxxxxxxxxxxxxxxxxx<mailto:dan.bale@xxxxxxxxxxxxxxxxxxxxx>>

wrote:

Keep kicking that can down the road!

Dan Bale
Sr. IT Systems Engineer
Prime Therapeutics

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx<mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx>> On Behalf Of

VERNON HAMBERG Owner via MIDRANGE-L

Sent: Friday, January 3, 2025 2:21 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx>>;

midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>

Subject: Re: SQL function WEEK_ISO for years beyond 2039

Of course, this change to 1970 as the base date means that any date

with 2 digit year that was between 1940 and 1969 is now magically a century
later.

Cheers
Vern

*** CONFIDENTIALITY NOTICE: The information contained in this

communication may be confidential, and is intended only for the use of the
recipients named above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution, or
copying of this communication, or any of its contents, is strictly
prohibited. If you have received this communication in error, please return
it to the sender immediately and delete the original message and any copy
of it from your computer system. If you have any questions concerning this
message, please contact the sender. ***

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription

related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

The information transmitted herein is confidential information intended only for the viewing and use of the individual recipient named above. If you are not the intended recipient, you are hereby notified that any review, use, communication, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone or reply e-mail, delete this message and destroy any printed copies. Thank you.