<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:st1 =
"urn:schemas-microsoft-com:office:smarttags"><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3132" name=GENERATOR><o:SmartTagType
name="PostalCode"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="State"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="City"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="Street"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="address"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="place"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceType"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><o:SmartTagType
name="PlaceName"
namespaceuri="urn:schemas-microsoft-com:office:smarttags"></o:SmartTagType><!--[if !mso]>
<STYLE>st1\:* {
BEHAVIOR: url(#default#ieooui)
}
</STYLE>
<![endif]-->
<STYLE>@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><FONT face="Courier New" color=#0000ff size=2><FONT
face=Arial></FONT></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><FONT
face=Arial></FONT></FONT> </DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><FONT face=Arial>R18 (example
using Birth.Bate from the Person file</FONT></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2><FONT face=Arial>string
xResult1; <BR>xResult1 = (vBirthDate).ToString("D4/YMD").Convert("/",
"");<BR>return (string)xResult1;</FONT></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face="Courier New"><FONT color=#0000ff><FONT size=2><SPAN
class=440205914-19072007><FONT face=Arial>R17</FONT></SPAN>
</FONT></FONT></FONT></DIV>
<DIV><FONT face="Courier New" color=#0000ff size=2>CONVERT(<SPAN
class=440205914-19072007>'</SPAN>/<SPAN class=440205914-19072007>'</SPAN>,<SPAN
class=440205914-19072007>''</SPAN>,OCONV(<SPAN
class=440205914-19072007><fieldname></SPAN>,<SPAN
class=440205914-19072007>'</SPAN>D4/<SPAN class=440205914-19072007>MDY'</SPAN>))
</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
download-list-bounces@cedarville.edu
[mailto:download-list-bounces@cedarville.edu] <B>On Behalf Of </B>Moyers,
Debra S<BR><B>Sent:</B> Wednesday, July 18, 2007 2:48 PM<BR><B>To:</B>
download-list@cedarville.edu<BR><B>Subject:</B> [Download-List]
date<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Anyone know how to output a date
MMDDYYYY without any separators?<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks!<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><STRONG><B><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Debbie
Moyers</SPAN></FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">***********************************</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><STRONG><B><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Business
Analyst</SPAN></FONT></B></STRONG><o:p></o:p></P>
<P class=MsoNormal><st1:place w:st="on"><st1:PlaceName w:st="on"><FONT
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Lincoln</SPAN></FONT></st1:PlaceName><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">
<st1:PlaceName w:st="on">Memorial</st1:PlaceName> <st1:PlaceType
w:st="on">University</st1:PlaceType></SPAN></FONT></st1:place><o:p></o:p></P>
<P class=MsoNormal><st1:Street w:st="on"><st1:address w:st="on"><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">6965
Cumberland Gap Pkwy</SPAN></FONT></st1:address></st1:Street><o:p></o:p></P>
<P class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><FONT face=Arial
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Harrogate</SPAN></FONT></st1:City><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">,
<st1:State w:st="on">TN</st1:State> <st1:PostalCode
w:st="on">37752</st1:PostalCode></SPAN></FONT></st1:place><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">(423)
869-6469</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><A
href="mailto:debra.moyers@lmunet.edu">debra.moyers@lmunet.edu</A></SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">***********************************</SPAN></FONT><o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV><!--qsdbegin-->
<P> </P><BR>
<HR color=#d2d3d2 noShade>
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication may contain material protected by the
attorney-client privilege. If you are not the intended recipient or the person
responsible for delivering the e-mail to the intended recipient, be advised
that you have received this e-mail in error and that any use, dissemination,
forwarding, printing, or copying of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately notify the offices
designated information technology person by telephone at 800-325-0900. You
will be reimbursed for reasonable costs incurred in notifying
us.<!--qsdend--><BR></BLOCKQUOTE></BODY></HTML>