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

[JonWadey@xxxxxxxxxxxxx]

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.