Brian Dunning's FileMaker Custom Functions

Search Results

18 functions found:

1.   AddDays ( theDate; DaysToAdd )
  Average rating: 3.7
Andrew Sasaki
Given a date and a number of days, returns the date that many days later.
 
2.   DaysDifference ( Date1 ; Date2 )
  Average rating: 4.2
Andrew Sasaki
Returns the number of days difference in two dates; returns a negative number if the second date is earlier than the first.
 
3.   DaysDifferenceAbs ( Date1; Date2 )
  Average rating: 4.5
Andrew Sasaki
Returns the number of days difference in two dates.
 
4.   getDomain ( theAddress )
  Average rating: 4.3
Andrew Sasaki
parses the domain name from an email address or URL
 
5.   getSelectedText
  Average rating: 4.8
Andrew Sasaki
Returns the value of the currently selected text
 
6.   getTopLevelDomain ( theAddress )
  Average rating: 4.4
Andrew Sasaki
Parses the top level domain from an email address or URL
 
7.   LastDayInstance ( theDate; NameOfDay )
  Average rating: 4.6
Andrew Sasaki
Returns the last instance of a given day in the month of the date
 
8.   listFieldTypes ( listOfFields )
  Average rating: 4.5
Andrew Sasaki
Returns a tab-delimited list of fields & field type info for every field on the current layout
 
9.   listRelationships ( listOfTables )
  Average rating: 4.5
Andrew Sasaki
Generates a list of relationships from a list of tables for the current active file
 
10.   makeEmailAddress ( name1 ; name1CharacterLimit ; name2 ; name2CharacterLimit ; separator ; domain )
  Average rating: 4.5
Andrew Sasaki
generates standardized email addresses
 
11.   MonthEndsOnDayName ( theDate )
  Average rating: 4.3
Andrew Sasaki
Returns the name of the day of the week the month ends on.
 
12.   MonthEndsOnDayOfWeek ( theDate )
  Average rating: 4.1
Andrew Sasaki
Returns the number of the day of the week the month ends on.
 
13.   MonthLength ( theDate )
  Average rating: 4.4
Andrew Sasaki
Returns the number of days in the month of the date supplied.
 
14.   NextWeekday (theDate)
  Average rating: 4.5
Andrew Sasaki
Calculates the next weekday (Mon-Fri) of a given date
 
15.   NextWeekEndDay (theDate)
  Average rating: 4.4
Andrew Sasaki
Determines the next weekend day after a given date.
 
16.   PaddedText ( Source; FillChar; NumberOfChars )
  Average rating: 4.4
Andrew Sasaki
Pads a text string to a specific number of characters using a fill character.
 
17.   SQL_DateTime_to_Date ( DateTime )
  Average rating: 3.9
Andrew Sasaki
Converts SQL DateTime value to month/day/year date
 
18.   upcCheckDigit ( upcString )
  Average rating: 0.0
Andrew Sasaki
Calculates UPC code check digit for any length UPC code. NOTE: Requires FMP 18 or later
 

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: