insert filemaker date into mySQL

[Darren Burgess]

I am attempting to insert from filemaker a date into a mySQL date field. mySQL dates are configured as yyyy-mm-dd.

I am using this calc to convert the date:

Year ( Workshop::Start Date ) & SerialIncrement ( "-00" ; Month ( Workshop::Start Date ) ) & SerialIncrement ( "-00" ; Day ( Workshop::Start Date ) )

This will correctly convert the date, however the script generates a 500 error - Date value does not meet validation entry options.

The filemaker field is a date field. the mySQL field is also type date.

Any ideas?

Darren Burgess