G'day Cameron > Of course MySQL stores dates in YYYY-MM-DD > whilst filemaker uses DD-MM-YYYY 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 week). Create a new layout in FMP with only the fields you wish to export. Change the date format of the date field to yyyy/mm/dd. In the export dialog, make sure you have "Format output using current layout" selected.
Now when you export your file, make sure you are on this layout first - the dates will be in the correct format for MySql. cheers kim --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
