Brian Dunning's FileMaker Custom Functions

mySQL_TimeStamp_to_Date ( mySQLTimeStamp )

Takes a mySQL TimeStamp and Parser out the Date

  Average rating: 4.5 (32 votes) Log in to vote

Dean Bedford   Dean Bedford
PLANet Systems Group
www.planetsg.com

Share on Facebook Share on Twitter

  Sample input:
20040519113444
  Sample output:
5/19/2004

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

We do lots of work with FMPro acting as a Front End to mySQL databases. This handy this function allows us to parse out the Date from the mySQL TimeStamp string.

 

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.