Maybe that is your problem! It could be FileGateway is correctly converting the data and you setting is unconverting it. What is your DATE FOR seting?
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Luc Delcoigne Sent: Monday, November 08, 2010 2:48 PM To: RBASE-L Mailing List Subject: [RBASE-L] - re: import problem Jan , I did a "show date seq" and I got the right DDMMYYYY. Strange... Luc From: jan johansen<mailto:[email protected]> Sent: Monday, November 08, 2010 9:40 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - re: import problem Luc, Listen to Dennis! Mine was for the formating Jan -----Original Message----- From: Dennis McGrath <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Mon, 8 Nov 2010 14:35:58 -0600 Subject: [RBASE-L] - re: import problem Change DATE SEQ to DDMMYYYY before importing? Experiment Dennis McGrath ________________________________ From: [email protected]<mailto:[email protected]> [mailto: [email protected]] On Behalf Of Luc Delcoigne Sent: Monday, November 08, 2010 2:32 PM To: RBASE-L Mailing List 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.
