Brian Dunning's FileMaker Custom Functions

GetTextAsDate ( dateTxt ; formatTxt )

Convert a date string of various formats into a FMP date value

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

Simon Brown   Simon Brown
beezwax datatools, inc.

Share on Facebook Share on Twitter

  Sample input:
GetTextAsDate ("20080616"; "yyyymmdd")
  Sample output:

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

Although FileMaker's built-in GetAsDate function is somewhat forgiving with its input, this function was designed to handle those that aren't covered, with 8 date formats supported, or over 40 specific variations in all. It is not fully internationalized however, since some calculations assume dates are in the mm/dd/yyyy format.

IMPORTANT: requires a separate helper function, GetMonthAsNumber ( to convert a month name to its ordinal.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.