RE: [SYS21] Converting system Date in Jba date format within Qu ery

[Geac User <geacuser@xxxxxxxxx>]

I'm guessing you have to define the result fields DAY,
MONTH and YEAR previously using a substr function or
something.  Correct?
Cheers
--- "Ellsworth, Bob" <Bob.Ellsworth@pollak.com> wrote:
>
>
DAY(CURRENT(DATE))+(MONTH(CURRENT(DATE))*100)+((YEAR(CURRENT(DATE))-1900)*10
> 000)
>
> -BobE
> * bob.ellsworth@pollak.com
>
>
> > -----Original Message-----
> > From:       JonWadey@mst-ltd.co.uk
> [SMTP:JonWadey@mst-ltd.co.uk]
> > Sent:       Wednesday, December 18, 2002 11:23 AM
> > To: jbausers-l@midrange.com
> > Subject:    [SYS21]   Converting system Date in Jba
> date format within
> > Query
> >
> > This is a multipart message in MIME format.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Doe's any body know of a way of converting the
> current system date into a
> > JBA format within Query.
> >
> > I can manage to do this the other way ie convert a
> jba date to a normal
> > calendar date.
> >  eg 1021225   to  25/12/02 but I need to reverse
> this.
> >
> > thanks in anticipation
> >
> > jon
> >
> >
> > This E-mail message, including any attachments, is
> intended only for the
> > person or entity to which it is addressed, and may
> contain confidential
> > information.
> >
> > If you are not the intended recipient, any review,
> retransmission,
> > disclosure,copying, modification or other use of
> this E-mail message or
> > attachments is strictly forbidden.
> >
> > If you have received this E-mail message in error,
> please contact the
> > author and delete the message and any attachments
> from your computer.
> >
> > You are also advised that the views and opinions
> expressed in this E-mail
> > message and any attachments are the author's own,
> and may not reflect the
> > views and opinions of M&S Toiletries Ltd.
> >
> > This e-mail message and any attached files have
> been scanned for the
> > presence of computer viruses.
> > _______________________________________________
> > 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.
> >
> >
>
_________________________________________________________________
> This electronic mail transmission contains
> confidential information intended
> only for the person(s) and/or organization named.
> Any use, distribution,
> copying or disclosure by or to any other person
> outside your organization is
> strictly prohibited. If you received this
> transmission in error, please send
> an electronic mail message to postmaster@pollak.com
> so we may instruct you
> regarding its disposition.
> _______________________________________________
> 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