Frank,
First have a look at your settings especially the time, does it look like: hh:mm:ss There is no comma needed between date and time It should not be a problem to import this column directly as date time. Hope this helps Tony From: [email protected] [mailto:[email protected]] On Behalf Of Frank Taylor Sent: dinsdag 17 maart 2015 14:27 To: RBASE-L Mailing List Subject: [RBASE-L] - Import CSV and DATETIME I have a export file that I am importing that contains a column of DateTime that imports as Text, I then alter the table to add a DATETIME column so I can order the data. However I cannot seem to directly convert the Text Column in to the DateTime Column with an Update {Table} set (RBaseDateTimeColumn) = (Datetime(TextDateTimeCol)) In the table the Text Date time looks like 03/17/15 00:00:00 I am assuming because the Datetime function is looking for a comma between the Date and Time it fails. My work around is to do a CURSOR through the data and set a variable defined as Datetime to the Text DateTime and then insert that variable into the DateTime Column, but that take a really long time for all these records. Is there a better way that I am not thinking of ? n Frank Frank Taylor - Director of Information Technology F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 Email: [email protected]
