Razzak, Thanks for your reply.
I am importing into a new table, and have the following settings:- Date Input DDMMYYYY Default Century 20 Century threshold YEAR is 0 The second column in the spreadsheet is a date field (ie set the format to a number and you get 38121 etc, set it to date you see 15/5/2004). I have tried setting the B column in the new table to both DATE and NOTE types. Can you please clarify your comment re how the column should be set in RBASE - should it work with the column set to a DATE type ? (All the other columns, which are just text, appear in the correct columns, as expected.) Should I try pasting the date column as values in Excel and then import the column as a TEXT field or should RBase do the conversion for me ? Thanks for your assistance. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Sent: Wednesday, 2 March 2005 3:55 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Date Conversion - Gateway At 09:21 PM 3/1/2005, John Docherty wrote: >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. John, Are you importing the data into a *new* table or existing table? FYI, R:BASE column defined as DATE, will NOT accept the data as NOTE. You'll have to check the table structure and column sequence. Does the existing table structure (column sequence and data types) match the cell sequence and data type of XLS spreadsheet? What are the DATE FORMAT, DATE SEQUENCE, DATE YEAR and DATE CENTURY settings of your database? I suggest you re-visit the table structure vs. XLS structure and then use the GATEWAY IMPORT option to import Very Best R:egards, Razzak. -- 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
