returns field names and contents of all the field are on a layout (repeatingField and related records included)
Convert a filemaker number-value into a SQL-numbervalue
All redundant returns will be removed. Leading, trailing and the extra ones between lines.
Remove redundant leading and trailing carrige-returns
Calculate date from the given fiscal weeknumber in the given year at the given Firstweekday
Convert a timestamp for use in an SQL Query.
Convert a time for use in an SQL Query.
Wrap text in single quotes, for use with SQL queries. The purpose of the Substitute is to "escape" any internally embedded apostrophes, e.g., O'Malley becomes 'O''Malley', which SQL will convert into O'Malley
Quote a field name for use in a FileMaker SQL statement. Prevent hard-coding it's value.
Convert a date for use in an SQL Query.
Returns date parsed from text in the format of "YYYY-MM-DD".
Returns values existing more than once in a list
Quote a table name for use in a FileMaker SQL statement. Prevent hard-coding it's value.
Gets de documents path for Mac and PC
Returns a date that is "n" working days from StartDate.