Re: Filemaker Pro and Dates

2002-05-30 Thread Kim Kohen
G'day Cameron Of course MySQL stores dates in -MM-DD whilst filemaker uses DD-MM- and so when I import my delimited text file MySQL interprets the dates incorrectly. I can't seem to find a way of changing the date format in Filemaker, This can be done easily (we do it every

Filemaker Pro and Dates

2002-05-29 Thread Cameron Murdoch
Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have exported the filemaker records as tab delimited files

Re: Filemaker Pro and Dates

2002-05-29 Thread Paul DuBois
At 23:45 +0100 5/29/02, Cameron Murdoch wrote: Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem: I am trying to convert and import a fairly convoluted Filemaker Pro 5 database to MySQL. I have

RE: Filemaker Pro and Dates

2002-05-29 Thread Cameron Murdoch
PROTECTED] Subject: Re: Filemaker Pro and Dates Do you have any experience with Perl? Perhaps a quick script would convert your tab delimited files to the proper format? Bradley Cameron Murdoch wrote: Hi all, I apologise if this question has been asked recently; I have checked the list

RE: Filemaker Pro and Dates

2002-05-29 Thread Gordon
- From: Cameron Murdoch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 5:46 PM To: [EMAIL PROTECTED] Subject: Filemaker Pro and Dates Hi all, I apologise if this question has been asked recently; I have checked the list archives and could not see anything. This is my problem