Re: Date Comparison yyyymm

this makes me laugh.....
fortunately for me, I didn't have an "idiot manager" - instead, a
supportive one who knew this was a real issue.

but I did deal with some of the comments from others..... "there was no
problem" -- and like you, worked our tails off to make sure there were no
problems.


Diane



From: Roger Harman <roger.harman@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/11/2017 11:02 AM
Subject: Re: Date Comparison yyyymm



Our ERP uses CYMD (7p 0) dates pervasively. That's not going to change.

I remember Y2K very well. Had to convince a skeptic general manager at a
previous employer that it was real.

For testing, his statement was "just change the date on the <expletive>
computer and see what happens". Had to convince him that IBM absolutely
recommended against that. What an idiot!

Had the night tech shut down the box at 23:30 and I went in at 00:30 to
bring it up. When we had no issues, I had to suffer thru the GM's remarks
of "See, it wasn't a problem". Duh, we worked our tails off on it. What
an idiot!

Did I mention that he was an idiot? Same guy wanted an 8-day fiscal week
with two Mondays. "How do the financials compare prior year by day?" I
asked. Glazed blank stare in response.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power








From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of
dmmueller@xxxxxxx <dmmueller@xxxxxxx>
Sent: Wednesday, October 11, 2017 5:12 AM
To: Midrange Systems Technical Discussion
Subject: Re: Date Comparison yyyymm

Roger,

"If they are numeric (which, sadly, the dates in our system are)"

ah... the Y2K project forced us to convert every character or numeric
field to a true date field. Big project, but a good project.
True date fields are great!

I guess I'm showing some age for anyone with those Y2K projects - who
remembers?

Diane Mueller



From: Roger Harman <roger.harman@xxxxxxxxxxx>
To: Midrange Systems Technical Discussion <MIDRANGE-L@xxxxxxxxxxxx>
Date: 10/10/2017 02:06 PM
Subject: Re: Date Comparison yyyymm



If they are numeric (which, sadly, the dates in our system are), I cast
(YYYYMMDD / 100) as an integer and get the numeric equivalent of YYYYMM.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power







From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of
dmmueller@xxxxxxx <dmmueller@xxxxxxx>
Sent: Tuesday, October 10, 2017 6:57 AM
To: MIDRANGE-L@xxxxxxxxxxxx
Subject: Date Comparison yyyymm

Group,
I have a date field "payment date" that I need to compare to current date,


but only comparing the year & month.
Any payments received in the current month should be disregarded,

I know this is simple, and I'm over thinking it .

Diane Mueller