ParseDate ( text )
Returns the first valid date found from a text string.
Average rating: 4.3 (37 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This recursive function parses the supplied text and returns the first word that is a valid date. The function only recognises dates entered in the current system format. If there are no valid dates the function returns a null value.
To improve the success rate each word is filtered to remove non-numeric characters (except for potential date delimiters).
liverMD, Newark NJ
Feb 8, 2010
Trying to set up this function in Edit custom function. My text field is designated "Import". When I try to save, I get the following message for ParseDate
ParseDate( RightWords( Import ; WordCount( Import ) - 1 ) )
"This Function cannot be found"
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.