I was asked this question today & can't remember the answer!! Anyone any ideas?

Wed, 1 Oct 2003 12:32:29 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C38839.9B67A440
Content-Type: text/plain;
	charset="iso-8859-1"

Chris, this doesn't work for 7.10, but it does work in 8.30 and up at least,
probably worked in 8.10 and up.  8.xx is set up to handle date and time
datatypes in a much more friendly manner than 7.10. We discussed changing
VMSDATE to report the time by default in 8.30, but decided that it would
break too many reports out there, so we didn't do it.  

I haven't tried it with other formats, but feel free to try them out and
report to the list what you find.  I can't think why it wouldn't work, but I
can't promise anything.

-----Original Message-----
From: Chris Sharman [mailto:chris.sharman@ccagroup.co.uk]
Sent: Wednesday, October 01, 2003 12:13 PM
To: Hamilton, Allison; PowerH List
Subject: Re: I was asked this question today & can't remember the
answer!! Anyone any ideas?

Hamilton, Allison wrote:
> Because VMSDATE does not report the time by default, never has.  You can 
> force it out using output scale and picture as in:
> 
>  REPORT VMS_DATE_SYS PICTURE "^^^^/^^/^^ ^^:^^:^^.^^^"  OUTPUT SCALE 9

I never knew this was posible - I've always used dateextract to define a 
temp, which is horribly messy, particularly when you want input as well 
as display.

What versions is this supported from ?
Does it support various formats, or just yyyymmdd ?

Thanks,
Chris

-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.

Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum.  Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details. 

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C38839.9B67A440
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: I was asked this question today &amp; can't remember the =
answer!! Anyone any ideas?</TITLE>
</HEAD>
<BODY>

Chris, this doesn't work for 7.10, but it does work =
in 8.30 and up at least, probably worked in 8.10 and up.&nbsp; 8.xx is =
set up to handle date and time datatypes in a much more friendly manner =
than 7.10. We discussed changing VMSDATE to report the time by default =
in 8.30, but decided that it would break too many reports out there, so =
we didn't do it.&nbsp;

<P><FONT SIZE=3D2>I haven't tried it with other formats, but feel free =
to try them out and report to the list what you find.&nbsp; I can't =
think why it wouldn't work, but I can't promise anything.</FONT></P>

-----Original Message-----
 From: Chris Sharman [<A =
HREF=3D"mailto:chris.sharman@ccagroup.co.uk">mailto:chris.sharman@ccagro=
up.co.uk</A>]
 Sent: Wednesday, October 01, 2003 12:13 PM
 To: Hamilton, Allison; PowerH List
 Subject: Re: I was asked this question today &amp; =
can't remember the
 answer!! Anyone any ideas?

<P><FONT SIZE=3D2>Hamilton, Allison wrote:</FONT>
<BR><FONT SIZE=3D2>&gt; Because VMSDATE does not report the time by =
default, never has.&nbsp; You can </FONT>
<BR><FONT SIZE=3D2>&gt; force it out using output scale and picture as =
in:</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt;&nbsp; REPORT VMS_DATE_SYS PICTURE =
&quot;^^^^/^^/^^ ^^:^^:^^.^^^&quot;&nbsp; OUTPUT SCALE 9</FONT>
</P>

<P><FONT SIZE=3D2>I never knew this was posible - I've always used =
dateextract to define a </FONT>
<BR><FONT SIZE=3D2>temp, which is horribly messy, particularly when you =
want input as well </FONT>
<BR><FONT SIZE=3D2>as display.</FONT>
</P>

<P><FONT SIZE=3D2>What versions is this supported from ?</FONT>
<BR><FONT SIZE=3D2>Does it support various formats, or just yyyymmdd =
?</FONT>
</P>

<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Chris</FONT>
</P>
<BR>
<BR>

<P><FONT =
SIZE=3D2>---------------------------------------------------------------=
--------</FONT>
</P>

Any views expressed in this message are those of the =
sender and not
 necessarily those of CCA Group.&nbsp; The =
unauthorized use, disclosure,
 copying or alteration of this message is =
forbidden.&nbsp; The contents of
 this message may be confidential and/or privileged, =
copyright CCA Group
 and are intended solely for the use of the =
individual or entity to whom
 they are addressed.&nbsp; Whilst this message has =
been scanned, CCA Group
 cannot guarantee that it is virus free or compatible =
with your systems
 and accepts no responsibility for any loss or damage =
arising from its
 use. The recipient is advised to run their own =
anti-virus software. If
 you receive this message in error please =
contact
 postmaster@ccagroup.co.uk immediately, destroy any =
copies and delete it
 from your computer systems.

Join us at Cognos' biggest event of the year =
Enterprise 2003, The Cognos Business Forum.&nbsp; Taking place in =
over 25 cities around the world, it's an opportunity for Business and =
IT leaders to learn about strategies for driving performance. Visit =
<A HREF=3D"http://www.cognos.com/enterprise03" =
TARGET=3D"_blank">http://www.cognos.com/enterprise03</A> for more =
details.

<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information.&nbsp; If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so.&nbsp; Thank you.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C38839.9B67A440--