2 Replies Latest reply on Jan 24, 2010 12:16 PM by daveslc

    Getting FM date into Mysql date field

    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