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