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

Wed, 1 Oct 2003 12:32:51 -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.A886DD30
Content-Type: text/plain

This sort of thing has always been supported. But don't get too excited.
What's happening here is that the use of PIC changes the way QUIZ treats the
type from a date to a numeric. So QUIZ substitutes the number in the VMSDATE
into the PIC. That's why the OUTPUT SCALE is needed. If you want to do any
formatting, you still need to extract and manipulate.

Bob Deskin              
Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

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.A886DD30
Content-Type: text/html
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=3DUS-ASCII">
<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>

This sort of thing has always been supported. But =
don't get too excited. What's happening here is that the use of PIC =
changes the way QUIZ treats the type from a date to a numeric. So QUIZ =
substitutes the number in the VMSDATE into the PIC. That's why the =
OUTPUT SCALE is needed. If you want to do any formatting, you still =
need to extract and manipulate.

<P><FONT SIZE=3D2>Bob =
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>Product Manager, Application Development Tools, =
Cognos Inc.</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: =
(613) 727-1178</FONT>
<BR><FONT SIZE=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON =
K1G 4K9 CANADA</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.
 =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
 Mailing list: powerh-l@lists.swau.edu
 Subscribe: &quot;subscribe&quot; in message body to =
powerh-l-request@lists.swau.edu
 Unsubscribe: &quot;unsubscribe =
&lt;password&gt;&quot; in message body to =
powerh-l-request@lists.swau.edu
 <A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
 This list is closed, thus to post to the list you =
must be a subscriber.

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