RE: *MDY Valid Dates

Saving data as CSV or TAB delimited, then opening it in Excel is asking for trouble.

I hate Excel - it modifies data in an effort to "help" you.

If the end result is Excel, I would create that directly. There are lots of tools that will accomplish that.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art Tostaine, Jr.
Sent: Wednesday, October 9, 2024 2:51 PM
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.

Greg Wilburn
Director of IT
301.895.3792 ext. 1231