Re: [SYS21] Converting system Date in Jba date format within Query

Elegant.  Nice.
--- Richard_Caldicott@tandybrands.com wrote:
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> This is the way I do it in DEFINE RESULT FIELDS.....
>
> Field       Expression
>  DATE        CURRENT(DATE)
>
> D           digits(adte08)
>
> DT
>
substr(d,4,2)||'/'||substr(d,6,2)||'/'||substr(d,2,2)
>
> Richard
> _______________________________________________
> This is the GEAC/JBA System 21 Users (JBAUSERS-L)
> mailing list
> To post a message email: JBAUSERS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
> or email: JBAUSERS-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/jbausers-l.
>


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com