× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: convert a date --> (WARNING) <--
  • From: BillsVilla@xxxxxxx
  • Date: Tue, 16 Jan 2001 17:30:42 EST

In a message dated 1/16/2001 4:56:30 PM Eastern Standard Time,
tuohyp@attglobal.net writes:


Adam, I am sure this will be one of many replies - but there are none there
at
the moment!

    D NumDate         S              8  0
    D ISODate         S               D
    C     *YMD          Move      NumDate       ISODate

HTH

Paul Tuohy

"Ray, Adam" wrote:

> This one's probably easy, but I wanted to know the BEST way to do this.
> I have a date stored in the format yyyymmdd (packed decimal, 8 digits, 0
> decimal). I want to convert it to the *ISO standard format (YYYY-MM-DD)
so I
> can perform the SUBDUR calculation on it. What is the easiest/fastest/most
> efficient way to do this? I am using ILE RPG on V4R2M0.


Only one thing missing...

Don't forget to do:

          *MDY        TEST(D)          NumDate                          50

Only move the date to the ISO field if it passes the test.

Otherwise you will get an invalid date error if it encounters something like
a zero date field or even if something has 022999 because it knows when a
leap year is.

Just thought I would warn you ...

Bill

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.