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

