AnsweredAssumed Answered

Getting FM date into Mysql date field

Question asked by daveslc on Jan 24, 2010
Latest reply on Jan 24, 2010 by daveslc

Title

Getting FM date into Mysql date field

Post

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...

 

Any thoughts?

 

thanks

Dave

 

Outcomes