Re: [SYS21] Posting Police - not -- SYSTEM21

Sometimes I feel embarrassed that I don't know
something I think I "should" and I feel safer posting
this way.  It has nothing to do with posting police.

I often believe that what is obvious to some is not to
others and the others might benefit from the asking.
In this instance I was hoping to benefit the others by
way of the asking.

I wish you all the peace of the season.
--- "Jansson, Stefan" <stefan.jansson@eljer.com>
wrote:
> Is Geac still monitoring this list and cracking down
> on participants to the point where there is a need
> to post things anonymously?  I thought they'd
> ENCOURAGE sharing of information between users and
> staff ... but what do I know.
>
> Stefan Jansson
> Eljer (Not a JBA customer)
> Dallas, TX
>
> -----Original Message-----
> From: Geac User [mailto:geacuser@yahoo.com]
> Sent: Wednesday, December 18, 2002 10:52 AM
> To: jbausers-l@midrange.com
> Subject: RE: [SYS21] Converting system Date in Jba
> date format within Qu
> ery
>
>
> 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
> _______________________________________________
> 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 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