help with functions

Tue, 3 Aug 2004 09:42:00 -0400

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4795F.A73E01EA
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I assume that this is more than a simple report or display which is
handled almost automatically.
=20
1) Use DATEEXTRACT to pull out the pieces and concatenate them.
=20
2) You may be able to use the ASCII function. Or use the FORMATNUMBER
function.
Bob Deskin             =20
Senior Product Manager, Application Development Tools, Cognos Inc.=20
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178=20
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA=20
	-----Original Message-----
	From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
	Sent: August 3, 2004 9:16 AM
	To: powerh-l@lists.sowder.com
	Subject: help with functions
=09
=09
	Hello - Could someone help me with 2 conversion function
	=20
	1)Convert a date field to    YYYY/MM/DD - character format
	2)Convert an integer 999999 to character 9999.99
	=20
	Thanks.
	=20
	=20
	-----Original Message-----
	From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of
Mikael.Olesen@qss-uk.com
	Sent: Monday, August 02, 2004 6:52 AM
	To: powerh-l@lists.sowder.com
	Subject: ORD () and CHR () functions
	=20
	Hello
	Cant remember how I get the ASCII value of a character and the
other way around,
	Just like PASCAL's (a real language) ORD () and CHR ()
functions.
	Anyone?
	Kind Regards
	Mikael Olesen
=09
=09
	=
r=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 DISCLAIMER
=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=3D
	This message is intended only for the use of the person(s)=20
	(\"Intended Recipient\") to whom it is addressed. It may contain

	information, which is privileged and confidential. Accordingly=20
	any dissemination, distribution, copying or other use of this=20
	message or any of its content by any person other than the
Intended=20
	Recipient may constitute a breach of civil or criminal law and
is=20
	strictly prohibited. If you are not the Intended Recipient,
please=20
	contact the sender as soon as possible.
=09
	Reed Business Information Ltd. and its subsidiary companies
	Tel: +44 (0)20 8652 3500
=09
=09
=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=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 =20
       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.=20
=20

------_=_NextPart_001_01C4795F.A73E01EA
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<META content=3D"Microsoft Word 10" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C4793A.7FA0DF90" rel=3DFile-List><!--[if gte =
mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
	font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; =
mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
	FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
A:link {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {
	COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {
	COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {
	COLOR: purple; TEXT-DECORATION: underline; text-underline: single
}
P {
	FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
	COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply; =
mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: =
10.0pt; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; =
mso-bidi-font-family: Arial
}
SPAN.GramE {
	mso-style-name: ""; mso-gram-e: yes
}
DIV.Section1 {
	page: Section1
}
</STYLE>
<!--[if gte mso 10]>
<style>
 /* Style Definitions */=20
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";}
</style>
<![endif]--></HEAD><BODY lang=3DEN-US style=3D"tab-interval: .5in" =
vLink=3Dpurple link=3Dblue><DIV>
<DIV><SPAN class=3D224453813-03082004><FONT face=3DArial color=3D#0000ff =
size=3D2>I=20
assume that this is more than a simple report or display which is =
handled almost=20
automatically.</FONT></SPAN></DIV>
<DIV><SPAN class=3D224453813-03082004><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D224453813-03082004><FONT face=3DArial color=3D#0000ff =
size=3D2>1) Use=20
DATEEXTRACT to pull out the pieces and concatenate =
them.</FONT></SPAN></DIV>
<DIV><SPAN class=3D224453813-03082004><FONT face=3DArial color=3D#0000ff =

size=3D2>&nbsp;</DIV>
<DIV>2) You=20
may be able to use the ASCII function. Or use the FORMATNUMBER=20
function.</DIV>
<DIV>
Bob=20
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
 Senior =
Product=20
Manager, Application Development Tools, Cognos Inc. =
 <SPAN=20
lang=3Den-us>bob.deskin@cognos.com (613) =
738-1338 ext 7268=20
FAX: (613) 727-1178 3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9=20
CANADA </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
 <DIV></DIV>
 <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
 face=3DTahoma size=3D2>-----Original Message----- From:=20
 powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] On=20
 Behalf Of Viet Nguyen Sent: August 3, 2004 9:16 =
AM To:=20
 powerh-l@lists.sowder.com Subject: help with=20
 functions </DIV>
 <DIV class=3DSection1>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hello =
&#8211; Could someone=20
 help me with 2 conversion <SPAN=20
 class=3DGramE>function<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">1)Convert<FONT=20
 face=3DArial color=3Dnavy size=3D2><SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> a date =
field to<SPAN=20
 style=3D"mso-spacerun: yes">&nbsp;&nbsp;&nbsp; YYYY/MM/DD =
&#8211; character=20
 format<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">2)Convert<FONT=20
 face=3DArial color=3Dnavy size=3D2><SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> an integer =
999999 to=20
 character 9999.99<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">Thanks.<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original=20
 Message----- From:=20
 powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]=20
 On Behalf Of=20
 Mikael.Olesen@qss-uk.com <SPAN=20
 style=3D"FONT-WEIGHT: bold">Sent: Monday, August 02, 2004 =
6:52=20
 AM To:=20
 powerh-l@lists.sowder.com <SPAN=20
 style=3D"FONT-WEIGHT: bold">Subject: ORD () and CHR ()=20
 functions
 <o:p>&nbsp;</o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Hello<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Cant remember how I get=20
 the <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">ASCII value of =
a=20
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">character and the other =
way=20
 around,<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Just like PASCAL's=20
 (a <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">real <FONT =

face=3DArial size=3D2>language)=20
 ORD () and <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">CHR ()=20
 functions.<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Anyone?<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Kind=20
 Regards<o:p></o:p>
 <SPAN=20
 style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Mikael=20
 Olesen<o:p></o:p>
 <FONT=20
 face=3D"Times New Roman" size=3D3><SPAN=20
 style=3D"FONT-SIZE: =
12pt"> r=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 DISCLAIMER=20
 =
=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=3D This message is intended only for the use of=20
 the person(s) (\"Intended Recipient\") to whom it is addressed. It =
may=20
 contain information, which is privileged and confidential. =
Accordingly=20
 any dissemination, distribution, copying or other use of this =
 message=20
 or any of its content by any person other than the Intended =
 Recipient may=20
 constitute a breach of civil or criminal law and is strictly =
prohibited.=20
 If you are not the Intended Recipient, please contact the sender =
as soon=20
 as possible. Reed Business Information Ltd. and its subsidiary=20
 companies Tel: +44 (0)20 8652=20
 =
3500 =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=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=20
 <o:p></o:p></DIV></BLOCKQUOTE></DIV>
<DIV>&nbsp;</DIV>
<DIV>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;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.

</DIV></BODY></HTML>

------_=_NextPart_001_01C4795F.A73E01EA--