Re: Date Comparison yyyymm

[Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>]

"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