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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
