[Download-List] date

[Brich, Richard W.]

R18 (example using Birth.Bate from the Person file
string xResult1; 
xResult1 = (vBirthDate).ToString("D4/YMD").Convert("/", "");
return (string)xResult1;
 
R17   
CONVERT('/','',OCONV(<fieldname>,'D4/MDY')) 

	-----Original Message-----
	From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Moyers, Debra
S
	Sent: Wednesday, July 18, 2007 2:48 PM
	To: download-list at cedarville.edu
	Subject: [Download-List] date
	
	

	Anyone know how to output a date MMDDYYYY without any
separators?

	 

	Thanks!

	 

	Debbie Moyers

	***********************************

	Business Analyst

	Lincoln Memorial University

	6965 Cumberland Gap Pkwy

	Harrogate, TN 37752

	(423) 869-6469

	debra.moyers at lmunet.edu

	***********************************

	 

	 


________________________________

	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.
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20070719/f7a688a5/attachment.html>