Functions in order of    date added  function name  comments  rating

Trim_CR ( Text )

Remove redundant leading and trailing carrige-returns

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

WeekFiscalToDate ( Firstweekday ; WeeknrOfYear ; Yearnr )

Calculate date from the given fiscal weeknumber in the given year at the given Firstweekday

    By menno   (0 comments Posted 25 February 2013   Rating:  unrated

SQLTimestamp ( theTimestamp )

Convert a timestamp for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLTime ( theTime )

Convert a time for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLQuote ( text )

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

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLField ( fieldOrFieldName )

Quote a field name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

    By Daniel Smith   (0 comments Posted 8 February 2013   Rating:  unrated

SQLDate ( theDate )

Convert a date for use in an SQL Query.

    By Daniel Smith   (0 comments Posted 6 February 2013   Rating:  unrated

GetAsSqlDate ( dateFromSqlResult )

Returns date parsed from text in the format of "YYYY-MM-DD".

    By Daniel Smith   (0 comments Posted 6 December 2012   Rating:  5.0

DoubleInList ( _values )

Returns values existing more than once in a list

    By Tanguy Colles   (5 comments Posted 22 November 2012   Rating:  unrated

SQLTable ( fieldForTableNameOrTableName )

Quote a table name for use in a FileMaker SQL statement. Prevent hard-coding it's value.

    By Daniel Smith   (0 comments Posted 14 November 2012   Rating:  unrated

setDocumentPath ( filename ; extension )

Gets de documents path for Mac and PC

    By Diego D'Alessio (solfilemaker)   (0 comments Posted 20 October 2012   Rating:  unrated

CompletionDate ( StartDate ; WorkingDays ; HolidayList )

Returns a date that is "n" working days from StartDate.

    By Daniele Raybaudi   (2 comments Posted 14 October 2012   Rating:  unrated

FileMakerFileFormat

Returns the file name extension or file suffix for the active version of FileMaker Pro or FileMaker Pro Advanced

    By DamonCasey   (0 comments Posted 20 September 2012   Rating:  unrated

GetValueIndex ( valueList ; valueString ; matchCase ; occurrence )

Retrieve the index of the matching valueString in the valueList with optional case-sensitivity and occurrence restrictions.

    By Lewis Lorenz   (0 comments Posted 4 August 2012   Rating:  unrated

sql.debug ( _executeSQL )

Helps you to debug your sql function in the data viewer

    By Andries Heylen   (8 comments Posted 28 July 2012   Rating:  5.0

 

« Previous 1 2 ... 4 5 6 7 8 ... 21 22 Next »

 

 

 

 

 

 

Top Tags

Text Parsing  (33)
List  (32)
Date  (28)
XML  (27)
Format  (23)
Sql  (22)
Dev  (20)
Debug  (17)

 

Interface  (15)
Layout  (15)
Text  (14)
Variables  (13)
Filter  (12)
Layout Objects  (11)
Design  (10)
Array  (8)