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
If you can load the data into MySQL, put the date field into a CHAR(10)
field. After the data load, add a date field using ALTER TABLE. You
should then be able to run something like
UPDATE TABLE tablename SET NewDate
= CONCAT(
RIGHT(OrigDate,4),
EMAIL 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 check
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 e
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 archives and could not see anything. This is my
