As far as I know, there is no "convert text to date" function. Wish there was!
I've also tried having an empty date column and doing a:
update table set datecoulmn = textcolumn
and that fails. So yes, I either do an RDate function or cursor through each
row to get the text variable, set a date variable = the text variable, then
write
to the date column.
Karen
-----Original Message-----
From: Tony IJntema <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Thu, Mar 27, 2014 8:13 am
Subject: [RBASE-L] - RE: Date problem while importing Excel sheet
Buddy,
I have done that.
The setting was dd-mm-yyyy (European setting)
I have imported the spreadsheet after having defined a RGW-file, but the
date values were ignored in the import, because they were delivered in a
different way.
The source of the problem is the poor date capabilities of Excel.
Maybe XLSX is working better, but I need to be sure that everybody can use
the spreadsheet, thats why I am using XLS.
In the meantime I have implemented a little conversion program by myself.
I extract the day, month and year value from the text field and then I
convert it to a date value using Rdate
It works fine and as far as I can see now it is solid like a rock.
Thank you for your suggestion.
Tony
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker
Sent: donderdag 27 maart 2014 13:49
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Date problem while importing Excel sheet
Tony
I think this starts with the Excel worksheet. Make sure the column is set
as date (mm/dd/yyyy) or whatever matches the database sequence. Not sure how
you are doing the import but during import you can select how the date being
imported is set.
Buddy
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema
Sent: Thursday, March 27, 2014 8:39 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Date problem while importing Excel sheet
Jason,
Normally this is what I am doing, but in this case the database is
distributed to a lot of people (everybody will have its own database).
So I am not in control of the situation.
I like to avoid complicated handling at the user site.
I have found a solution using the Rdate function, but I was hoping that I
missed a conversion function.
Tony
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Kramer,
Jason J
Sent: donderdag 27 maart 2014 13:12
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Date problem while importing Excel sheet
Can you dump to CSV and import that instead?
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Tony IJntema
Sent: Thursday, March 27, 2014 8:08 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Date problem while importing Excel sheet
Hi,
In one way or another Excel (xls) is always causing problems when I try to
import a date value in a table.
To avoid this I can import the date values as a text and then I like to
convert the text value into a date value.
Does anyone know a solution for converting text values to date values.
I cannot find this in the help
Tony
