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

["Dave Scalpone" <DScalpone@xxxxxxxxxxxxx>]

I use this in my column         DATE( CDAT32, CYYMMDD )
Then I used edit masks to change that to MM/DD/YY

Dave

-----Original Message-----
From: JonWadey@mst-ltd.co.uk [mailto: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.