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
