Brett- DateValue converts only the date. You need CDate instead. John Viescas, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Collings Sent: Saturday, July 01, 2006 4:00 AM To: [email protected] Subject: Re: [ms_access] Convert Text String to Actual Date/time variable Mike, DateValue is the expression DateValue("11/28/2006 11:30 AM") Brett At 13:12 01/07/06, you wrote: >Gang - > >Is it possible to change a string such as "11/28/2006 11:30 AM" to a >valid date/time format in Accces? > >Mike > > > > > > > >Yahoo! Groups Links > > > > > > > > > >-- >Internal Virus Database is out-of-date. >Checked by AVG Anti-Virus. >Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/06 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/06 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Groups gets a make over. See the new email design. http://us.click.yahoo.com/XISQkA/lOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
