Re: Date Comparison yyyymm

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

I do. I actually started putting YYYYMMDD numeric date fields in files
before the date data type existed. Switched to date data type after they
arrived. Still have a handful of files with numeric YYYYMMDD.

On Wed, Oct 11, 2017 at 8:12 AM, <dmmueller@xxxxxxx> wrote:

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

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


MIDRANGE-L mailing list archive (midrange.com)
archive.midrange.com
midrange.com MIDRANGE-L mailing list archive


Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


http://g-ec2.images-amazon.com/images/G/01/social/api-
share/amazon_logo_500500._V323939215_.png


Amazon.com: Online Shopping for Electronics, Apparel, Computers, Books,
DVDs & more
amzn.to
Online shopping from the earth's biggest selection of books, magazines,
music, DVDs, videos, electronics, computers, software, apparel &
accessories, shoes, jewelry, tools & hardware, housewares, furniture,
sporting goods, beauty & personal care, broadband & dsl, gourmet food &
just about anything else.


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD