That's interesteing John, I wasn't sure of my ground on whether time was included so I went to XP version's Help which said "for date and time" ... so I thought it was solid.
I love it when I learn something new every day Brett John Viescas wrote: > 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/ <http://www.viescas.com/> > (Paris, France) > For the inside scoop on Access 2007, see: > http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/> > > _____ > > From: [email protected] <mailto:ms_access%40yahoogroups.com> > [mailto:[email protected] > <mailto:ms_access%40yahoogroups.com>] On Behalf > Of Brett Collings > Sent: Saturday, July 01, 2006 4:00 AM > To: [email protected] <mailto:ms_access%40yahoogroups.com> > 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] > > -- Brett Collings Strengthening Families Administrator D2D 46422 DDI (04) 916 3422 ------------------------------- This email message and any attachment(s) is intended only for the person(s) or entity(entities) to whom it is addressed. The information it contains may be classified as IN CONFIDENCE and may be legally privileged. If you are not the intended recipient any use, disclosure or copying of the message or attachment(s) is strictly prohibited. If you have received this message in error please notify us immediately and destroy it and any attachment(s). Thank you. The Ministry of Social Development accepts no responsibility for changes made to this message or to any attachment(s) after transmission from the Ministry. ------------------------------- [Non-text portions of this message have been removed] 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/
