Formula Function Reference

Our Formula Function Reference

Formula Function Reference

• Returns t converted to lower case.
October 14th, 2009 - 4:10 PM
Tags:
• This function can take 2 or more arguments of any data type, as long as they are all the same type. The result is the same data type as the arguments. Null values are ignored. For Numbers, returns the argument that is greatest. For Text, returns the argument that sorts last alphabetically. For Durations, returns the argument that is longest. For Dates returns the argument that is latest. For Date/Time, returns the argument that is latest. For TimeOfDays, returns the argument that is latest. For Booleans returns the argument that is largest, treating false as less than true.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the leftmost n characters from the Text argument t.
October 14th, 2009 - 4:10 PM
Tags:
• Returns true if d is a weekday, otherwise false.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the last day of the month in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the last day of the period in which the date falls. The cycle of periods is defined by the given Duration p, repeated in sequence starting at the given reference date r. If the period p is not a whole number of days, the fractional part is ignored.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the last day (Saturday) of the week in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the last day of the year in which the date falls.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the largest multiple of the duration y which is less than or equal to the duration x.
October 14th, 2009 - 4:10 PM
Tags:
• Returns the fractional part of the Number n. The result is the same sign as n. For any Number n, Int(n) + Frac(n) is the same as n.
October 14th, 2009 - 4:10 PM
Tags: