RE: *MDY Valid Dates

That'll certainly do it. I had that happen a few times at a previous employer before we figured out it was user error - opening/saving the downloaded file.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power



-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art Tostaine, Jr.
Sent: Wednesday, October 9, 2024 11:51 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: *MDY Valid Dates

Thanks for all the replies. The customer sent correct dates but apparently
combining a bunch of files in excel and saving as CSV saved 10/05/24 as
10/5/24.

I'll use the SQL method next time. That looks nice.

On Wed, Oct 9, 2024 at 2:22 PM x y <xy6581@xxxxxxxxx> wrote:

Use SQL.

Open a session and type this:
VALUES DATE(TIMESTAMP_FORMAT('10/9/24', 'MM/DD/RRRR'))

or this:
VALUES DATE(TIMESTAMP_FORMAT('1/9/24', 'MM/DD/RRRR'))

...and you'll get the results you're looking for.

On Tue, Oct 8, 2024 at 3:26 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

We are receiving a tab delimited file from a partner with dates like
10/5/24. I'm storing it in an alpha field.

I tried converting to *ISO using %DATE(mydate:*MDY) and it fails in the
monitor loop.

Thanks, Art
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.