Getting FM date into Mysql date field
I am trying to insert records into a mysql database from filemaker. I am running into problems with a date field in fm that won't insert nicely into mysql.
The fm format is 1/12/2010. The mysql format is yyyy-mm-dd
I have tried: Year ( testindex::date ) & "-" & Month ( testindex::date ) &"-" & Day ( testindex::date )
but mysql didn't like that...