[RBG7-L] - Re: Date Conversion - Gateway

[John Docherty]

Gary / Dennis,   Thanks for your comments – sorry for the delay in replying. I have tried using workbooks, and a new table with either a note or a date field defined for the appropriate column. The results are still not what I want – I start with a date such as ‘14/5/2004’ in the spreadsheet, where the column and cell have a date format, and I end up with 38121 (note), or a null (date), in my RBase ‘date’ column. Not quite what I wanted.   Any further suggestions would be welcomed.   Thank you.   Regards,   John Docherty From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, 28 February 2005 1:44 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Date Conversion - Gateway   Check to see if the Excel document is saved as a worksheet or a workbook.  To work properly, it needs to be saved as a workbook.  Rbase does a much better job of importing the correct data for dates, if it is in the workbook format.        ----- Original Message ----- From: John Docherty To: RBG7-L Mailing List Sent: Sunday, February 27, 2005 3:55 AM Subject: [RBG7-L] - Date Conversion - Gateway   I have imported an Excel spreadsheet containing dates, (format dd/mm/yyyy), but end up with integers in the date column, as per the spreadsheet ‘format’ for storing dates (ie 38385 etc). My question is, is there a simple way to change these to a date recognised by Rbase ? (I have tried importing these with the format set to match the spreadsheet format but end up with nulls.)  Have I missed the obvious solution here ?   Thank you.   Regards,   John Docherty   -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.5.0 - Release Date: 25/02/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.306 / Virus Database: 266.5.0 - Release Date: 25/02/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.5.5 - Release Date: 1/03/2005