All my Date of Births come out like this now: 1978-02-03 00:00:00
At 02:46 PM 6/2/2002, you wrote: >If it doesn't work, create a new date/time field and run a CF template that >loops through every record in the table, reads each text field, creates an >ODBC date and then inserts it into the new field. Insert NULL if the date is >blank or otherwise invalid. After you're done, delete (or rename) the old >field and rename the new one with the old name. > >Jim > >----- Original Message ----- >From: "Gyrus" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Sunday, June 02, 2002 2:06 PM >Subject: Re: Date query help > > > > ----- Original Message ----- > > From: "Brian Simpson" <[EMAIL PROTECTED]> > > I just had a look, The Access field type is TEXT. can I just change it > > to > > time/date and be ok? or will I loose all the data that's in that field? > > --------------------------- > > > > Is there much data? I reckon you may well lose the current data, but > > I've never tried this. Make a copy of the database file and try it out! > > > > - Gyrus > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists