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

I would have thought that they would be pleased, it leaves the helpdesk free


-----Original Message-----
From: Geac User [mailto:geacuser@yahoo.com]
Sent: Wednesday, December 18, 2002 5:31 PM
To: jbausers-l@midrange.com
Subject: Re: [SYS21] Posting Police - not


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


***************************************************************************
Important - Please read
***************************************************************************

The statements and opinions expressed in this message are those of the author
and do not necessarily reflect those of the company.

The information contained in this e-mail is confidential. It may also be legally
priveleged. It is intended only for the stated addressee(s) and access to it by
any other person is unauthorised. If you are not an addressee, you must not
disclose, copy, circulate or in any way use or rely on the information contained
in this e-mail. Such unauthorised use may be unlawful. If you have received this
e-mail in error, please inform us immediately at administrator@pattonair.com
and delete it and all copies from your system.

All inbound and outbound e-mails and any attachments are monitored and
scanned by virus/ content checking software. While showing due care we
accept no liability, so scan all attachments.