# Search Results

14 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. FormatTimestamp ( timestampValue , format ) Average rating: 0.0 Lewis Lorenz, Lorenz Companies Returns the Timestamp date and/or time formatted as specified in format. 5. 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. 6. 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. 7. 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. 8. 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. 9. 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. 10. 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. 11. 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. 12. 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. 13. UniqueWindowName ( name ) Average rating: 0.0 Lewis Lorenz, Lorenz Companies Starting with 14. 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 16 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: