Re: *MDY Valid Dates

I did add the / after more reading. This is driving me crazy! 8/25/2024
didn't convert either. changing to 08/25/2024 let it convert.

I'm getting RNX0112

Message . . . . : Date, Time or Timestamp value is not valid.
Cause . . . . . : The Date, Time or Timestamp value is not valid. Some
examples of values which are not valid are:
-- A date of 1994/02/31, which is not possible.
-- A time of 01/03:04, which does not have correct separators.
Recovery . . . : Correct the value of the Date, Time or Timestamp field.

On Wed, Oct 9, 2024 at 12:40 AM Daniel Gross <daniel@xxxxxxxx> wrote:

Hi Art,

can you tell us, which message is received in the job log? There are many
possible reasons, why a conversion may fail - and also the value, that
generates the message would be good.

Regards,
Daniel

Am 09.10.2024 um 00:26 schrieb Art Tostaine, Jr. <atostaine@xxxxxxxxx>:

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.