FilterValuesByTest ( text ; varName ; test ; include_1 )
Returns a text filtered by a test
Average rating: 3.7 (57 votes) Log in to vote
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Regular expressions in FileMaker !
This is a very customisable function, read the comments to know more about it.
Virtually, any type of text parsing is possible with this function and FilterWordsByTest
UPDATE : I would now recommend the use of CustomList, by Agnès Barouh : http://www.briandunning.com/cf/747, or FilterList : http://www.briandunning.com/cf/771
Feb 5, 2016
Hi, i'm trying to set a filter between the same field named "date"
i want to display a list if products who were purchased between a rage
i have one field named "dateofpurchase"
for example: I want to know who products were purchased between 01/01/2015 .and. 16/02/2015
thanks for your help
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.