PathParser ( thePath , returnElementPHFNE ) PathParser returns the path directory, home directory, full filename and extension, filename, or extension from a folder and/or file path string. Easily extract path elements from thePath. Preserves FileMaker Pro file reference prefixes (file:, … Continue reading →
PathMaker ( thePath , theFile , pathSeparator ) PathMaker returns a properly formatted folder and/or file path by processing and combining thePath, theFile and pathSeparator. Easily change path separator in thePath. Preserves FileMaker Pro file reference prefixes (file:, filemac:, and … Continue reading →
GetValueIndexByPosition ( valueList , valueString , matchCase , occurrence , positionLCR ) GetValueIndexByPosition retrieves the index of the value in a value list whose left, center or right portion matches the value string search text. Returns 0 if not found. … Continue reading →
Easter ( theYear , method ) Easter custom function returns Julian, Orthodox, or Gregorian Easter dates for years 326 to 4000 (or 4099). Year validation changes the year to the minimum year that can be calculated for the calendar method. … Continue reading →
NPVV ( cashFlowsList , interestRate ) NPVV calculates Net Present Value of a value list of cash flows (cashFlowsList) with a specified rate of return (interestRate). Used to determine the present value of an investment by the discounted sum of … Continue reading →
IRR ( cashFlowsList , guessRate ) IRR calculates Internal Rate of Return of a value list of cash flows (cashFlowsList) using an initial guessed rate of return (guessRate). The parameter guessRate defaults to .0001 if initially blank. IRR calculates the … Continue reading →
FormatNumber ( number , format ) FormatNumber is a one-pass FileMaker Pro custom function that formats a number using intuitive, free-form format options that completely mimic FileMaker Pro’s number data type formatting. Formatting options can also be specified via escaped … Continue reading →
FormatDateTime ( dateValue , timeValue , format ) FormatDateTime formats FileMaker Pro date and time data using PHP Date formatting syntax. Returns a string of the dateValue and/or timeValue as specified in format. If dateValue or timeValue are empty current … Continue reading →
GetValueIndex ( valueList , valueString , matchCase , occurrence ) GetValueIndex returns the index number of the first matching valueString in the valueList. Returns 0 if not found. Toggle case-sensitive searching by passing a boolean through matchCase. And, search for … Continue reading →