Luc, In your R:BASE database and before you import issue the command SET DATE FORMAT DD/MM/YYYY After the import, set it back using SET DATE FORMAT MM/DD/YYYY
Jan -----Original Message----- From: "Luc Delcoigne" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 8 Nov 2010 21:32:20 +0100 Subject: [RBASE-L] - re: import problem Hi, I have begun to convert the data of my access database to RBase. in an Access table I have a date column in the format DD/MM/YYYY. When I import this table with the File Gateway, I get a format MM/DD/YYYY in the Rbase table for that same column, meaning that all dates higher than de 12th of a month are not imported as Rbase thinks it is month 13 where it should read day 13. What am I overlooking here ? Luc D.
