Brian Dunning's FileMaker Custom Functions

Search Results

12 functions found:

1.   Easter ( theYear ; method1J2O3G )
    Average rating: 4.5
  Lewis Lorenz, Lorenz Companies
  Returns Julian, Orthodox, or Gregorian Easter dates for years 326 to 4000 (or 4099).
   
2.   FormatDateTime ( dateValue ; timeValue ; format )
    Average rating: 3.9
  Lewis Lorenz, Lorenz Companies
  Returns the dateValue and/or timeValue formatted as specified in format, using PHP-like coding, and allowing for escaped non-formatted text.
   
3.   FormatNumber ( number ; format )
    Average rating: 4.0
  Lewis Lorenz, Lorenz Companies
  Non-recursive function returns a text string of the 'number' in the requested 'format'.
   
4.   GetValueIndex ( valueList ; valueString ; matchCase ; occurrence )
    Average rating: 3.9
  Lewis Lorenz, Lorenz Companies
  Return index to value in valuelist. Search case sensitive or insensitive. Search for occurrence from front or end.
   
5.   GetValueIndexByPosition ( valueList ; valueString ; matchCase ; occurrence ; positionLCR )
    Average rating: 4.2
  Lewis Lorenz, Lorenz Companies
  Retrieve the index of the matching valueString in valueList by comparing valueString against the left, center (middle), or right of each value in valueList.
   
6.   IRR ( cashFlowsList ; guessRate )
    Average rating: 4.3
  Lewis Lorenz, Lorenz Companies
  Calculate Internal Rate of Return of a value list of cash flows with an initial guessed rate-of-return, using the Newton-Raphson method.
   
7.   NPVV ( cashFlowsList ; interestRate )
    Average rating: 4.8
  Lewis Lorenz, Lorenz Companies
  Calculate Net Present Value of a value list (not a repeating field) of cash flows with a specified rate of return.
   
8.   PathMaker ( thePath ; theFile ; pathSeparator )
    Average rating: 4.8
  Lewis Lorenz, Lorenz Companies
  Returns a properly formatted folder and/or file path by processing and combining thePath, theFile, and pathSeparator.
   
9.   PathParser ( thePath ; returnElementPHFNE )
    Average rating: 4.3
  Lewis Lorenz, Lorenz Companies
  PathParser returns the directory path, home directory, full filename and extension, filename, or extension from a folder and/or file path string.
   
10.   StopwatchMilliseconds ( ctrlStartTimeLapListStopClear ; prefixText ; variableName )
    Average rating: 3.3
  Lewis Lorenz, Lorenz Companies
  Creates and manages a value list variable to track milliseconds with full stopwatch controls: Start, Time, Lap, List, Stop, or Clear.
   
11.   StopwatchSeconds ( ctrlStartTimeLapListStopClear ; prefixText ; variableName )
    Average rating: 3.7
  Lewis Lorenz, Lorenz Companies
  Creates and manages a value list variable to track seconds with complete stopwatch controls: Start, Time, Lap, List, Stop, or Clear.
   
12.   XIRR ( cashFlowList ; cashFlowDateList ; guessRate )
    Average rating: 4.4
  Lewis Lorenz, Lorenz Companies
  Returns extended internal rate of return - XIRR. Mimics Excel XIRR function.
   

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 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: