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 →