Ken,
Have you tried importing into a column that is formatted as a datetime column? Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Ken Shapiro Sent: Monday, December 20, 2010 5:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel Steve: The format on the spreadsheet was changed to mm/dd/yyyy. Jim: Unless the date is entered as a string, meaning ="06/01/2010"; dates are stored internally as a whole number plus fraction. The fraction represents times. You can see this if you set the format to General. AS I said above the formatting was set to: mm/dd/yyyy. Regards, Ken From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Monday, December 20, 2010 6:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Question On Gateway Import Using Excel Ken, I would check the formatting in Excel. I really haven't noticed any of my clients who import excel spreadsheets on a regular basis ever having anything but normal date formatting. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Ken Shapiro Sent: Monday, December 20, 2010 4:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Question On Gateway Import Using Excel Hello All, Using the Gateway Import command against an Excel spreadsheet, I am not able to import date fields successfully, against R:BASE 9.1. I don't remember ever trying to import a date field from an spreadsheet and can't find any information in the help about it. Dates in Excel as stored as numbers with a fraction. When trying to import the column from the spreadsheet into a table it goes into a date column as null. Any helpful suggestions? Regards, Ken
