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