#DateFormat(Left(sixDigitString, 2)&"/"&Mid(sixDigitString, 2,
2)&Right(sixDigitString, 2), "mmmm d, yyyy")#

-----Original Message-----
From: Jay Wigginton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 11, 2000 4:05 PM
To: [EMAIL PROTECTED]
Subject: Date from string


I am looking for a quick and easy way to convert a 6 character string that
represents the date into an actual date... example...

060198 --> June 1, 1998

072399 --> July 23, 1999

040400 --> April 4, 2000


thanks
Jay

----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to