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


This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2020 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].