Brian Dunning's FileMaker Custom Functions

MySQL_DateTime ( fm_date ; fm_time )

Takes date and time values and returns the equivalent of a MySQL DateTime value

  Average rating: 4.6 (30 votes) Log in to vote

Gary Czychi   Gary Czychi
GC Consulting
http://www.Czychi.com/

Share on Facebook Share on Twitter

  Sample input:
MySQL_DateTime (Get(CurrentDate; "13:25:09")
  Sample output:
"2010-04-15 13:25:09"

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Takes date and time values and returns the equivalent of a MySQL DateTime value.

Date and Time can be anything that FileMaker considers to be a Date or a Time (like the Get(CurrentDate) or the Get(CurrentTime) functions.

It returns the MySQL DateTime as text.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.