Hi Peter -- Thank you for your tip. I keep making my Access date records text, because I am afraid a search will not find them. I also really liked The Fellowship of the Ring -- it is a beautiful movie.
Julia Green Julia Computer Consulting http://www.juliagreen.com --- Peter Tilbrook <[EMAIL PROTECTED]> wrote: > Another tip is when designing your database, you can > set the default valu > e > of your date field to "Now()". Then whenever a new > record is created it w > ill > default to the date/time the record was made. > > Peter Tilbrook > ColdFusion Applications Developer > 2/13 Murrung Crescent > Ngunnawal ACT 2913 > > >> > > All that is gold does not glitter, > Not all those who wander are lost; > The old that is strong does not wither, > Deep roots are not reached by the frost. > From the ashes a fire shall be woken, > A light from the shadows shall spring; > Renewed shall be blade that was broken, > The crownless again shall be king. > > >> > > Three Rings for the Elven-kings under the sky, > Seven for the Dwarf-lords in their halls of stone, > Nine for Mortal Men doomed to die, > One for the Dark Lord on his dark throne > In the Land of Mordor where the Shadows lie. > One Ring to rule them all, One Ring to find them, > One Ring to bring them all and in the darkness bind > them > In the Land of Mordor where the Shadows lie. > > J.R.R. Tolkien - The Lord of the Rings > Episode I Coming December 2001 > > -----Original Message----- > From: Kris Pilles [mailto:[EMAIL PROTECTED]] > Sent: Friday, 28 December 2001 05:54 > To: CF-Talk > Subject: RE: Inserting dates into access > > > Thanks > ~! > > -----Original Message----- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 27, 2001 1:53 PM > To: CF-Talk > Subject: Re: Inserting dates into access > > > You would use the cf function createdodbcdate (for > just the date) or > createodbcdatetime to include the time as well. > Note: time fields in a > database are real numbers so if you insert only the > date then the time > will > be set to 12:00 midnight as well (there really is no > such thing as a > date > field that doesn't contain a time as well). > > Example: > > <cfquery ...> > insert into mydb .... > #createodbcdatetime(now())# > </cfquery> > > HTH, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - > 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail > Server <<< Vote for > iMS as > the CFDJ Reader's Choice Awards Most Innovative > Product >>> > http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cf > m > >>> Find out how iMS Stacks up to the competition: > >>> http://www.coolfusion.com/imssecomparison.cfm > > ----- Original Message ----- > From: "Kris Pilles" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, December 27, 2001 1:39 PM > Subject: Inserting dates into access > > > > What is the method of formatting dates prior to > inserting them into > > accxess so that they will remain dates instead of > times > > > > Kris Pilles > > Website Manager > > Western Suffolk BOCES > > 507 Deer Park Rd., Building C > > Phone: 631-549-4900 x 267 > > E-mail: [EMAIL PROTECTED] > > > > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
