× 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.



If it is no century date (6,0 dec):  e.g. YYMMDD
        FLDDATE = (%REM((%SUBDT(CDATE:*Y)):100) * 10000)
                +  (%SUBDT(CDATE:*M) * 100)
                +  %SUBDT(CDATE:*D);



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Captain Jerry
Sent: Wednesday, April 19, 2006 1:52 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Date Type -to- Numeric

Hey Rex, that worked nice :-)

     1       D CDATE           S               D   DATFMT(*ISO) Inz(*Sys)
     2       D FLDDATE         S              8  0
     3
     4        /FREE
     5
     6         FLDDATE = (%SUBDT(CDATE:*Y) * 10000) +
     7                   (%SUBDT(CDATE:*M) * 100)   +
     8                   %SUBDT(CDATE:*D);
     9
    10         *InLR = *On;
    11
    12        /END-FREE



                                                                        B
Debug . . .

F3=End program   F6=Add/Clear breakpoint   F10=Step   F11=Display variabl
F12=Resume       F17=Watch variable   F18=Work with watch   F24=More keys
FLDDATE = 20060419.


On 4/19/06, Rex Capio <rex_capio@xxxxxxxxxxxxxxxxxxxxx> wrote:
>
> Try this
>
> D CDATE S       D       DATFMT(*ISO)
> D FLDDATE       S       8  0
>
> /FREE
>
> FLDDATE = (%SUBDT(CDATE:*Y) * 10000)
>        + (%SUBDT(CDATE:*M) * 100)
>        + %SUBDT(CDATE:*D);
>
> /END-FREE
>
>
> HTH
>
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Michael_Schutte@xxxxxxxxxxxx
> Sent: Wednesday, April 19, 2006 12:57 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Date Type -to- Numeric
>
> Then I'm afraid that you'll either have to use the DS or use positional
> CSPECS.
>
> D NewIso          S               D   DatFmt(*ISO)
> C     *MDY          Move      Udate         NewIso
> C     *ISO          Move      NewIso        $TriSeqD
>
> Michael Schutte
>
>
>
>
>             "Captain Jerry"
>             <captainjerry@gma
>             il.com>                                                    To
>             Sent by:                  "RPG programming on the AS400 /
>             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>
>             midrange.com                                               cc
>
>                                                                   Subject
>             04/19/2006 12:52          Re: Date Type -to- Numeric
>             PM
>
>
>             Please respond to
>              RPG programming
>              on the AS400 /
>                  iSeries
>             <rpg400-l@midrang
>                  e.com>
>
>
>
>
>
>
> > Good try...
> >
> > %Int(%Char(%Date():*ISO0));
> > *RNF0325 30      1 The parameter for %INT or %INTH is not valid.
> >
> >
> > Michael Schutte
> >
> >
> >
> >
> >             "Captain Jerry"
> >             <captainjerry@gma
> >             il.com
> >                                                    To
> >             Sent by:                  "RPG programming on the AS400 /
> >             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>
> >             midrange.com
> cc
> >
> >
> Subject
> >             04/19/2006 12:26          Re: Date Type -to- Numeric
> >             PM
> >
> >
> >             Please respond to
> >              RPG programming
> >              on the AS400 /
> >                  iSeries
> >             <rpg400-l@midrang
> >                  e.com>
> >
> >
> >
> >
> >
> >
> > That would have been smart of me to include!
> >
> > V5R1
> >
> > Will either your R2 or R3 option work? (I'll be trying while I wait for
> a
> > response ~  Thanks...
> >
> >
> > On 4/19/06, Michael_Schutte@xxxxxxxxxxxx <Michael_Schutte@xxxxxxxxxxxx>
> > wrote:
> > >
> > > What version are you on?
> > >
> > > V5R2
> > >
> > > %Int(%Char(%Date():*ISO0));
> > >
> > > V5R3
> > >
> > > %Dec(%Date():*ISO);
> > >
> > >
> > > Michael Schutte
> > >
> > >
> > >
> > >
> > >             "Captain Jerry"
> > >             <captainjerry@gma
> > >             il.com
> > >                                                    To
> > >             Sent by:                  "RPG programming on the AS400 /
> > >             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>
> > >             midrange.com
> > cc
> > >
> > >
> > Subject
> > >             04/19/2006 12:04          Date Type -to- Numeric
> > >             PM
> > >
> > >
> > >             Please respond to
> > >              RPG programming
> > >              on the AS400 /
> > >                  iSeries
> > >             <rpg400-l@midrang
> > >                  e.com>
> > >
> > >
> > >
> > >
> > >
> > >
> > > Hi RPG'ers,
> > >
> > > I'm writing a simple utility to fix some data in a file, and brushing
> up
> > > on
> > > my /Free format coding as well.
> > >
> > > I can't seem to figure out how to get a Date Type field (*System Date)
> > > into
> > > our standard way of storing dates, which is Numeric 8,0 YYYYMMDD.
> > >
> > > Is there an easy way to do this without jumping through Data Structure
> > > hoops, or breaking out of /Free to use Move?
> > >
> > > Help!  and Thanks,
> > >
> > > //Jerry/
> > > --
> > > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> > list
> > > To post a message email: RPG400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > > or email: RPG400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/rpg400-l.
> > >
> > >
> > >
> > > --
> > > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> > list
> > > To post a message email: RPG400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > > or email: RPG400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/rpg400-l.
> > >
> > >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.