Comvert to a date when Day in text is included

's Computer Specifications

How do I convert the following to a date using something like CDate

Wednesday, March 22, 2006

I keep getting errors.

Thanks.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200603/1

's Computer Specifications

If you know for certain, that every date will always begin with the
day-name and then a comma - just take evrything after the first comma:

(untested)

dim s as string
s = "Wednesday, March 22, 2006"
....
? CDate (mid$ (s, instr(s, ",")+1))

HTH,
TC (MVP Access)
http://tc2.atspace.com

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plain text messages: original text included with paragraph markings?	ryanlink@gmail.com	Microsoft Outlook Discussion	1	24th Apr 2006 04:33 PM
Can I comvert a remote USB drive from FAT32 to NTFS? If so how (easyway).	dpost	Windows XP New Users	6	1st Apr 2006 06:26 PM
How to update a cell if a specific date is included in a date rang	=?Utf-8?B?bWdhdmlkaWE=?=	Microsoft Excel Setup	2	8th Oct 2005 12:53 AM
formula for cycle time from date -to-date w/o weekend included	Steve	Microsoft Excel Misc	3	29th Oct 2003 04:09 PM
Autonumber with date included	Yokim	Microsoft Access Database Table Design	3	16th Oct 2003 02:08 AM