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

In article
<b2a81186-816d-4df5-993d-6757b51d7e98 (AT) k39g2000yqd (DOT) googlegroups.com>,
Darren Burgess <darrenburgess (AT) cox (DOT) net> wrote:

A field set to yyyy-mm-dd is not a valid FileMaker date. If you want a
date in that format you would usually just change the formatting options
for the Field on the Layout(s).

BUT, since you're transferring to an SQL database that isn't going to
work. What you'll need to do is use a Text Field in FileMaker for the
converted date, and then perhaps have an extra Field in the SQL data base
that converts the imported FileMaker Text date into a proper Date.

Helpfull Harry )

On 6/9/2010 6:02 PM, Darren Burgess wrote:

What method are you using to move it to SQL? If you are using FM's
built-in ESS (external SQL sources) feature, then you just set the date
into the SQL field in FileMaker in the regular FM format (MM/DD/YYYY)
and FM takes care of the conversion to MySQL date format.

Thank you, this worked. BTW the method to insert was the set field
script step.

What other conversions does filemaker make automatically? where is
the documentation regarding this?

On 6/11/2010 3:56 AM, Darren Burgess wrote:
There's chapter five of the FM users' guide:
http://www.filemaker.com/support/pro...sers_guide.pdf

And also the DBA guide, "The External SQL Data Source
Feature in FileMaker Pro"
http://www.filemaker.com/downloads/pdf/sql_info_dba.pdf

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker Certified Developer
Associate Member, FileMaker Business Alliance