Brian Dunning's FileMaker Custom Functions

MySQL_DateTime_to_TimeStamp ( DateTime )

Convert MySQL DateTime value to FileMaker TimeStamp

  Average rating: 4.0 (35 votes) Log in to vote

Andy Knasinski   Andy Knasinski
NRG Software, LLC.
http://www.nrgsoft.com

Share on Facebook Share on Twitter

  Sample input:
MySQL_DateTime_to_TimeStamp ( "2006-12-18 14:57:30" )
  Sample output:
12/18/2006 2:57:30 PM

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

This custom function converts a MySQL (4.1) DataTime value to a FileMaker Pro TimeStamp format.

 

Comments

Woz   Woz, Perth
Apr 19, 2015
Warning: This outputs US format dates only (mm/dd/yyyy)
 
John Buckingham   John Buckingham, microGuidance
Aug 3, 2017
Thanks, Andy, for posting this...

Re: Woz's post; I amended the function as follows to output the date in the user's date format:

Timestamp (
Date ( Middle ( DateTime ; 6 ; 2 ) ; Middle ( DateTime ; 9 ; 2 ) ; Left ( DateTime ; 4 ) ) ;
GetAsTime ( RightWords ( DateTime ; 1 ) )
)
 

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.