Tony's right. I just created a text file with one value: '03/17/15 00:00:00' I made sure my time sequence and format were both HH:MM:SS, and I was able to import that directly into a DateTime column!
I also agree with Tony that there is no comma needed between date and time. The syntax of the Datetime function itself requires a comma: DateTime(DateCol, TimeCol) Karen -----Original Message----- From: Tony IJntema <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Mar 17, 2015 8:39 am Subject: [RBASE-L] - RE: Import CSV and DATETIME 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]
