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

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.