All
 
Function Name
Arguments
Result Type
Explanation
Examples
 
Type Conversion  (16 Functions) 
ToBoolean (Number n) Boolean Returns true if the Number n is a non-zero value, otherwise returns false. ToBoolean(1) returns true
ToBoolean(0) returns false
ToBoolean(null) returns false
ToBoolean (Text x) Boolean Converts the values "1", "true" or "yes" to true, other values to false. Case is ignored. ToBoolean("Yes") returns true
ToBoolean("0") returns false
ToDate (Date/Time x) Date Date/Time type fields have a date, time and time zone associated with them, while Dates do not have time and time zone. This function converts the Date/Time x into a Date by returning the Date, in the local time zone, in which Date/Time x falls. ToDate([Date Modified]) returns the Date the record was last modified
ToDate (Text x) Date Converts the text value x into a Date. x can be several of the popular date formats, including "January 30, 2000", "1/30/00", "2000/1/30", "1-30-2000" ToDate("Jan 30, 2000") takes the text "Jan 30, 2000" and returns it as a date type value.
ToFormattedText (Date d, Text f) Text Returns a Text value which is the formatted text version of the date specified. The Text argument to the function specifies the format. Choose one of: MMDDYYYY MMDDYY DDMMYYYY DDMMYY YYYYMMDD ToFormattedText(Date(2000,01,30),"MMDDYYYY")  returns "01-30-2013" 
ToFormattedText(Date(2000,01,30),"MMDDYY")  returns "01-30-13" 
ToFormattedText(Date(2000,01,30),"DDMMYYYY")  returns "30-01-2013" 
ToFormattedText(Date(2000,01,30),"DDMMYY")  returns "30-01-13" 
ToFormattedText(Date(2000,01,30),"YYYYMMDD")  returns "2013-01-30"
ToFormattedText (Date/Time t, Text f) Text Returns a Text value which is the formatted text version of the date/time specified. The Text argument to the function specifies the format. Choose one of: MMDDYYYY MMDDYY DDMMYYYY DDMMYY YYYYMMDD ToFormattedText([Date Created],"MMDDYYYY")  returns "01-30-2013 10:34 PM" 
ToFormattedText([Date Created],"MMDDYY")  returns "01-30-13 10:34 PM" 
ToFormattedText([Date Created],"DDMMYYYY")  returns "30-01-2013 10:34 PM" 
ToFormattedText([Date Created],"DDMMYY")  returns "30-01-13 10:34 PM" 
ToFormattedText([Date Created],"YYYYMMDD")  returns "2013-01-30 10:34 PM"
ToFormattedText (Duration d, Text f) Text Returns a Text value containing the formatted print representation of the Duration d, using the format f. The Text argument to the function specifies the format. Choose one of: HHMM HHMMSS MMSS MM MSECONDS SECONDS MINUTES HOURS DAYS WEEKS SMART ToFormattedText([Duration],"HHMM")  returns "01:12" 
ToFormattedText([Duration],"HHMMSS")  returns "01:02:03" 
ToFormattedText([Duration],"MMSS")  returns ":02:03" 
ToFormattedText([Duration],"MM")  returns ":02" 
ToFormattedText([Duration],"MSECONDS")  returns "83750000" 
ToFormattedText([Duration],"SECONDS")  returns "8375" 
ToFormattedText([Duration],"MINUTES")  returns "25.55" 
ToFormattedText([Duration],"HOURS")  returns "25.35" 
ToFormattedText([Duration],"DAYS")  returns "1.53" 
ToFormattedText([Duration],"WEEKS")  returns "0.1235" 
ToFormattedText([Duration],"SMART")  returns "23.434 hours"
ToFormattedText (Number n, Text f) Text Returns a Text value which is the formatted text version of the number specified. The Text argument to the function specifies the format. Choose one of: none_dot - returns the number formatted like 12345678.85 comma_dot - returns the number formatted like 12,345,678.85 comma_dot_2 - returns the number formatted like 1,23,45,678.85 none_comma - returns the number formatted like 12345678,85 dot_comma - returns the number formatted like 12.345.678,85 dot_comma_2 - returns the number formatted like 1.23.45.678,85 ToFormattedText(2394729834.85, "comma_dot") returns 2,394,729,834.85
ToNumber (Boolean b) Number Returns 0 if b is false, 1 if b is true. ToNumber(false) returns 0
ToNumber(true) returns 1
ToNumber (Text x) Number Returns the number represented by the Text value x. ToNumber("-12.3") returns -12.3
ToNumber("") returns null
ToText (<any> x) Text Returns a Text value containing the print representation of the argument x. ToText(3.4) returns "3.4"
ToText(null) returns ""
ToText(true) returns "1"
ToText(Date(2000,12,16)) returns "12-16-2000"
ToText(ToTimeOfDay("4pm")) returns "4:00 pm"
ToText(Hours(2)+Minutes(20)) returns "2:20"
ToText([Date Created]) returns "12-15-2000 10:34 PM"

ToText([Record Owner]) returns the user name or email address of the user who appears in the Record Owner field.

ToText([AssignedTo]), where AssignedTo is a list-user field type, returns a semi-colon separated list of the user names or email addresses of the users  who appear in the AssignedTo field.
ToTimeOfDay (Date/Time t) TimeOfDay Date/Time fields display the date and time. This function returns the TimeOfDay on which the Date/Time t falls in the local time zone. ToTimeOfDay([Last Modified])
ToTimeOfDay (Text x) TimeOfDay Converts the text value x into a TimeOfDay. x can be several of the popular time formats, including "3 pm", "3:04 am", "22:00", "2:03:29 am", "12:03:29.345". ToTimeofDay("16:32") returns the time 4:32pm
ToTimestamp (Date d) Date/Time Returns a Date / Time value which is 12:00 am of the given Date d in the local time zone (midnight at the beginning of the Date). ToTimestamp(Date(2000,7,4)) returns midnight on July 4, 2000.
ToTimestamp (Date d, TimeOfDay t) Date/Time Returns a Date / Time value which is at the given TimeOfDay t, on the given Date d in the local time zone ToTimestamp([Start Date], [Start Time])
ToWorkDate (Date d) WorkDate Converts a date d to a WorkDate. ToWorkDate([Finish]) takes a date value from the Finish field and returns it as a Workdate.

ToWorkDate(ToDate("10/31/2003")) returns a work date whose value is 10/31/2003
Numbers  (11 Functions) 
Abs (Number n) Number Returns the absolute value of the Number n. Abs(3.5) returns 3.5
Abs(-3.5) returns 3.5
Exp (Number n) Number Returns e raised to the nth power, where e is approximately 2.71828182845905 This exponential function is for use in logarithmic calculations that track growth. For example, you can use it to figure compounding interest. Exp(2) returns 7.389056 (which is e, or 2.71828182845905, to the 2nd power)

Exp(5) returns 148.413159 (e to the 5th power)
Frac (Number n) Number 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. Frac(3.4) returns 0.4
Frac(-2.3) returns -0.3
Int (Number n) Number Returns the integer part of Number n. Note that if n is a negative fraction, the result is closer to 0 than n is (compare to function Floor). Int(3.6) returns 3
Int(3) returns 3
Int(-3.6) returns -3
Ln (Number n) Number Returns the natural (base e) logarithm of n. Exp(Ln(72)) returns 72
Log (Number n) Number Returns the base 10 logarithm of n. Log(100) returns 2
10 ^ Log(72) returns 72
  Mod (Number n, Number m) Number Returns n modulo m. Mod implements 'clock' arithmetic; it models movement around a clock that is labeled with the numbers 0 to m-1. To get the result, just count n times around the clock. (Mod is the same as Rem for positive numbers, but different for negative numbers.) You might use this function to auto-assign tasks to staff members. For details, please read this article Mod(7,3) returns 1
Mod(-7,3) returns 2
Mod(7,-3) returns -1
Mod(-7,-3) returns -2

Sample auto-assign formula:

If (Mod([Record ID#],ToNumber([number_of_reps])) = 0, ToUser("jsmith"),
Mod([Record ID#],ToNumber([number_of_reps])) = 1, ToUser("bboop"),
Mod([Record ID#],ToNumber([number_of_reps])) = 2, ToUser("ppeabody"))
PV (Number rate, Number nskip, Number amt) Number Calculates the Present Value of a future payment. Rate is the discount rate for one time period. Nskip is the number of time periods before the payment occurs. Amt is the amount of the payment. PV(.10, 2, 121) returns 100
PV (Number rate, Number nskip, Number amt, Number npay) Number Calculates the Present Value of a series of future payments. Rate is the discount rate for one time period. Nskip is the number of time periods before the first payment occurs. Amt is the amount of each payment. Npay is the number of payments in the series, spaced one time period apart. PV(.10, 1, 100, 3) returns 248.69
Rem (Number n, Number d) Number Returns a number that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.) Rem(7,3) returns 1
Rem(-7,3) returns -1
Rem(7,-3) returns 1
Rem(-7,-3) returns -1
Sqrt (Number n) Number Returns the square root of n. Sqrt(9) returns 3
Sqrt(16) returns 4
Text  (22 Functions) 
Begins (Text u, Text v) Boolean Returns true if the text u begins with the text v, otherwise returns false. Begins("abcdef", "cd") returns false
Begins("abcdef", "abcd") returns true
Contains (Text u, Text v) Boolean Returns true if v is contained in u, otherwise returns false. Contains("abcdef", "cd") returns true
Contains([Status], "open") returns true if the Status field contains the word "open"
Ends (Text u, Text v) Boolean Returns true if the text u ends with the text v, otherwise returns false. Ends("abcdef", "cd") returns false
Ends("abcdef", "cdef") returns true
Left (Text t, Number n) Text Returns the leftmost n characters from the Text argument t. Left("abcd", 2) returns "ab"
Left (Text t, Text d) Text Returns the left part of a text value up to but not including the first occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. Left("abc/def",";/,") returns "abc"
Left("Michael Smith", " ") returns "Michael"
Length (Text t) Number Returns the number of characters in t. Length("abc") returns 3
List (Text d, Text t1, Text t2, ...) Text Concatenates (strings together) all arguments starting with the second argument, using the first argument as the delimiter between them. If one of the arguments is blank, it and the corresponding delimiter are omitted. List("-", "a", "b", "d") returns "a-b-d"

List(", ", "a", "b", "", "d") returns "a, b, d"

List(", ", [Last Name], [First Name]) returns "Last Name, First Name" if both fields are not empty, returns "Last Name" if [First Name] is empty, and returns "First Name" if [Last Name] is empty.

List("\n", "Name", "Address Line 1", "", List(", ", "City", "State"), "Zip") returns
"Name
Address Line 1
City, State
Zip"
Lower (Text t) Text Returns t converted to lower case. Lower("ABC") returns "abc"
Mid (Text t, Number p, Number n) Text Returns n characters from the middle of t, starting at position p. The first character is position 1. Mid("abcd", 2, 3) returns "bcd"
Mid("abcd", 4, 4) returns "d"
NotLeft (Text t, Number n) Text Returns what remains after excluding the leftmost n characters from the Text argument t. NotLeft("abcde", 2) returns "cde"
NotLeft (Text t, Text d) Text Returns what remains after excluding the left part of a text value up to and including the first occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter. NotLeft("abc/ def/ghi"," ;/,") returns "def/ghi"
NotLeft("Michael    Wissner", " ") returns "Wissner"
NotRight (Text t, Number n) Text Returns what remains after excluding the rightmost n characters from the Text argument t. NotRight("ABCDE", 2) returns "ABC"
NotRight (Text t, Text d) Text Returns what remains after excluding the right part of a text value starting at the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter. NotRight("abc/ def"," ;/,") returns "abc"
NotRight("Michael   Wissner", " ") returns "Michael"
PadLeft (Text textToPad, Number targetLength, Text paddingText) Text Extends text to a target length by adding padding to the left of the text. If the text is already the target length or longer, then there's no change. Otherwise, the padding text is added as necessary to reach the target length. NOTE: This function pads up to a limit of 50 characters. PadLeft("123", 5, "0") returns "00123"
PadRight (Text textToPad, Number targetLength, Text paddingText) Text Extends text to a target length by adding padding to the right of the text. If the text is already the target length or longer, then there's no change. Otherwise, the padding text is added as necessary to reach the target length. NOTE: This function pads up to a limit of 50 characters. PadRight("123", 5, "**") returns "123**"
Part (Text t, Number p, Text d) Text Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character. The first argument, t, is the value to be searched. The second argument, p, is the position of the part in the argument t. The first part starting on the left is position 1. Negative part numbers can be used to start from the right. The third argument, d, is a text value containing all the possible delimiter characters. If space is included in the delimiter list it is handled specially. It acts as a delimiter, but contiguous spaces surrounding a delimiter are ignored rather than each acting as a separate delimiter. Part("hh:mm:ss",1,":") returns "hh"
Part("hh:mm:ss",3,":") returns "ss"
Part("hh:mm:ss",-1,":") returns "ss"
Part("hh:mm",3,":") returns ""
Part("abc, def,ghi",2," ,") returns "def"
Part([Append],2,"[") returns all text from the Append field that lives between the first [ character and the second [ character. This example shows how to extract only the most recent entry from an append field.
Right (Text t, Number n) Text Returns the rightmost n characters from the Text argument t. Right("ABCD", 2) returns "CD"
Right (Text t, Text d) Text Returns the right part of a text value starting at the character after the last occurrence of a delimiter character. The first argument, t, is the value to be searched. The second argument, d, is a text value containing all the possible delimiter characters. Right("abc/def",";/,") returns "def"
Right("Michael Wissner", " ") returns "Wissner"
SearchAndReplace (Text textToSearch, Text searchText, Text replacementText) Text Replaces all occurrences of a given search text with the replacement text. Search is case sensitive. SearchAndReplace("John Smith", "John", "Jane") returns "Jane Smith"
Trim (Text t) Text Returns t with leading and trailing white space characters removed. White space characters are space, tab, CR and LF. Trim("  ABC ") returns "ABC"
Upper (Text t) Text Returns t converted to upper case. Upper("abc") returns "ABC"
URLEncode (Text t) Text Encodes the text t so that it can be used in a URL, by substituting special character combinations for certain reserved characters, like '&' and '=' and space. URLEncode("abc def&ghi=4") returns "abc+def%26ghi%3D4"
Durations  (15 Functions) 
Abs (Duration d) Duration Returns the absolute value of d. Abs(Weeks(3.5)) returns 3.5 weeks
Abs(Weeks(-3.5)) returns 3.5 weeks
Days (Number n) Duration Returns a Duration representing n days. This function takes a number and converts it into a Duration type value, expressed in days. Days(1.5) returns a 1.5 day duration
Days([Estimated # of days]) converts the numeric value in the Estimated # of days field into a duration expressed in days. The number doesn't change, just the data type.
Hours (Number n) Duration Returns a Duration representing n hours. This function takes a number and converts it into a Duration type value, expressed in hours. Hours(4) returns a 4 hour duration
[Intake Time]+Hours(2) returns the time of day from the Intake Time field plus two hours.
Hours([Test Length in Hours]) converts the numeric value in the Test Length in Hours field into a duration expressed in hours. The number doesn't change, just the data type.
Minutes (Number n) Duration Returns a Duration representing n minutes. This function takes a number and converts it into a Duration type value, expressed in minutes. minutes(42) returns a duration of 42 minutes.
Minutes([Test Length in Minutes]) converts the numeric value in the Test Length in Minutes field into a duration expressed in minutes. The number doesn't change, just the data type.
[Start Time] + minutes(90) returns the time of day that 90 minutes after the time of day in the Start Time field.
Mod (Duration n, Duration m) Duration Returns n modulo m. (Mod is the same as Rem for positive numbers, but different for negative numbers.) Mod(Days(4), Days(3)) =  Days(1)
Mod(Days(-4), Days(3)) =  Days(2)
Mod(Days(4), Days(-3)) = Days(-1)
Mod(Days(-4), Days(-3)) = Days(-2)
MSeconds (Number n) Duration Returns a Duration representing n milliseconds. This function takes a number and converts it into a Duration type value, expressed in milliseconds. Mseconds(250) returns a duration of 250 seconds.
Mseconds([Shutter Time]) converts the numeric value in the Shutter Time field into a duration expressed in milliseconds. The number doesn't change, just the data type.
Rem (Duration n, Duration d) Duration Returns a Duration that is the remainder after n is divided by d an integer number of times. (Mod is the same as Rem for positive numbers, but different for negative numbers.) Rem(Days(4), Days(3)) =  Days(1)
Rem(Days(-4), Days(3)) = Days(-1)
Rem(Days(4), Days(-3)) =  Days(1)
Rem(Days(-4), Days(-3)) = Days(-1)
Seconds (Number n) Duration Returns a Duration representing n seconds. This function takes a number and converts it into a Duration type value, expressed in seconds. seconds(120) returns a duration of 120 seconds.
seconds([100yd Dash Finish Time]) converts the numeric value in the 100yd Dash Finish Time field into a duration expressed in seconds. The number doesn't change, just the data type.
[Start Time] + seconds(10) returns the time of day that's 10 seconds after the time of day in the Start Time field.
ToDays (Duration d) Number Takes a Duration d, and returns the number of days contained in it. ToDays([Start Date] - Today()) returns the number of days until the Start date.

ToDays(Weeks(2)) returns 14
ToHours (Duration d) Number Takes a Duration d, and returns the number of hours contained in it. ToHours(Days(2)) returns 48
ToMinutes (Duration d) Number Takes a Duration d, and returns the number of minutes contained in it. ToMinutes(Hours(2)) returns 120
ToMSeconds (Duration d) Number Takes a Duration d, and returns the number of milliseconds contained in it. ToMSeconds(Seconds(2)) returns 2000
ToSeconds (Duration d) Number Takes a Duration d, and returns the number of seconds contained in it. ToSeconds(Minutes(2)) returns 120
ToWeeks (Duration d) Number Takes a Duration d, and returns the number of weeks contained in it. ToWeeks(Days(14)) returns 2
Weeks (Number n) Duration Returns a Duration representing n weeks. This function takes a number and converts it into a Duration type value, expressed in weeks. Weeks(2) returns a 2 week duration
Weeks([Weeks until Delivery]) converts the numeric value in the Weeks until Delivery field into a duration expressed in weeks. The number doesn't change, just the data type.
Dates  (27 Functions) 
AdjustMonth (Date d, Number m) Date Returns the date which is m months after the given date d, with the same day number. If the day doesn't exist in that month, the last day of that month is returned. AdjustMonth([Ordered On], 3) returns the date three months after the date in the Ordered On field.

AdjustMonth(ToDate("2/20/99"), 2) returns April 20, 1999
AdjustMonth(ToDate("4/29/99"), -2) returns February 28, 1999
AdjustYear (Date d, Number y) Date Returns the date which is y years after the given date d, with the same month and day. If the day doesn't exist in that month, the last day of that month is returned. AdjustYear([Last Appt], 1) returns the date one year after the date in the Last Appt field.
AdjustYear([Date],-1) returns the date one year before the value in the Date field,
AdjustYear(ToDate("2/20/99"), 2) returns February 20, 2001
AdjustYear(ToDate("2/29/00"), -1) returns February 28, 1999
Date (Number year, Number month, Number day) Date Creates a date from a year, month and day. Date(2000, 1, 10) returns the date January 10, 2000
Day (Date d) Number Returns the day of the month of the given Date d. Day([Start Date]) returns the day of the month for the date that appears in the Start Date field.

Day(ToDate("Jan 10, 2000")) returns 10
DayOfWeek (Date d) Number Returns the number of days by which the given date d follows the first day of the week (Sunday returns 0). DayOfWeek([Start Date]) returns the number of the day of the week for the date that appears in the Start Date field.
DayOfWeek(ToDate("Aug 23, 2000")) returns 3
DayOfWeek(ToDate("Aug 20, 2000")) returns 0
DayOfYear (Date d) Number Returns the number of days by which the given date d follows the first day of the year (January 1 returns 0). DayOfYear(ToDate("Jan 1, 2000")) returns 0
DayOfYear(ToDate("Jan 10, 2000")) returns 9
FirstDayOfMonth (Date d) Date Returns the first day of the month in which the date falls. FirstDayOfMonth([Order Date]) returns the first day of the month in which the Order Date occurs.

FirstDayOfMonth(Today()) returns the first day of the current month.
FirstDayOfPeriod (Date d, Duration p, Date r) Date Returns the first day of the period in which the date d 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. Useful for handling biweekly pay periods.

FirstDayOfPeriod([date field], Weeks(2), Date(2000,5,1)) returns the date that is the start of the two week period in which the date in the date field falls. The initial two week period that starts the cycle begins on May 1, 2000.


FirstDayOfPeriod(Today(), Days(365), Date(2005,7,1)) returns the date July 1st of the current year-long period. Between 7/1/06 and 7/1/07 this would be July 1, 2006. (As the years go on, this method won't account for leap years.)
FirstDayOfWeek (Date d) Date Returns the first day (Sunday) of the week in which the date falls. FirstDayOfWeek([Start Date]) returns the date of the Sunday (first day of the week) in which the Start Date occurs.
FirstDayOfWeek(ToDate("7/30/2007")) returns the date 7-29-07
FirstDayOfYear (Date d) Date Returns the first day of the year in which the date falls. FirstDayOfYear([Termination Date]) returns the first day of the year in which the Termination date occurs.

FirstDayOfYear(Today()) returns the first day of the current year.
IsLeapDay (Date d) Boolean Returns true if d is February 29. IsLeapDay([Date Due]) returns true if the value in the Date Due field falls on a leap day like 2/29/08.
IsLeapYear (Date d) Boolean Returns true if the date d falls in a leap year. IsLeapYear([Release Date]) returns true if the date in the Release Date field falls in a leap year like 2008. If it occurs in a non leap year, like 2007, the result is false.
IsLeapYear (Number y) Boolean Returns true if the year y is a leap year. IsLeapYear(2007) returns false.
IsLeapYear(2008) returns true.
IsWeekday (Date d) Boolean Returns true if d is a weekday, otherwise false. IsWeekday([Deliver On]) returns true if the date in the Deliver On field is a weekday. If not, the result is false.

IsWeekday(ToDate("6/20/2003")) returns true
LastDayOfMonth (Date d) Date Returns the last day of the month in which the date falls. LastDayOfMonth([Service Date]) returns the date of the last day of the month in which the Service Date occurs.

LastDayOfMonth(ToDate("2/12/2008")) returns 
02-29-2008
LastDayOfPeriod (Date d, Duration p, Date r) Date 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. LastDayOfPeriod([Payment Date], [Quarter Length in Days], [Fiscal Year Start Date]) returns the last day of the quarter in which the Payment Date falls.
LastDayOfWeek (Date d) Date Returns the last day (Saturday) of the week in which the date falls. LastDayOfWeek([Date A]) + Days(1) returns the Sunday date of the week that follows the one in which Date A falls.
LastDayOfYear (Date d) Date Returns the last day of the year in which the date falls. LastDayOfYear([Registration Date]) returns the last day of the year in which the Registration Date falls.

LastDayOfYear(Todate("August 4, 2009")) returns 12-31-2009
Month (Date d) Number Returns the month number of the Date d. January is month 1. Month([Start Date]) returns the number of the month within the date that appears in the Start Date field.

Month(ToDate("Jan 10, 2000") returns 1
NextDayOfWeek (Date d, Number n) Date Returns the first day after the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on. NextDayOfWeek([Date Submitted], 2) returns the first Tuesday that follows the Date in the Date Submitted field.
PrevDayOfWeek (Date d, Number n) Date Returns the last day before the given date d that falls on the weekday n. n is a number from 0 to 6 with Sunday being 0, Monday being 1, Tuesday being 2, and so on. PrevDayOfWeek([Date Due], 5) returns the date of the last Friday that occurse before the Date Due.
Today () Date Returns the current date in the local time zone. Today() - [Estimated Finish Date] calculates the duration since the Estimated Finish Date occurred.
ToWeekdayN (Date d) Date If the given date d is a weekday returns it, otherwise returns the next occurring weekday. To WeekdayN([Order Date]) returns the date in the Order Date field if it's a weekday. If not, it returns the date of the next weekday.

ToWeekdayN(ToDate("6/21/2003")) returns 6/23/2003
ToWeekdayP (Date d) Date If the given date d is a weekday returns it, otherwise returns the previously occurring weekday. ToWeekdayP(ToDate("6/21/2003")) returns 6/20/2003
WeekdayAdd (Date d, Number n) Date Returns the date that is n weekdays past the given date d. n may be negative to move backward in time. WeekdayAdd([Start], [Duration]) returns the date that results if you add the value in the Duration field to the date in the Start field and count only weekdays. 

WeekdayAdd(ToDate("6/20/2003"), 2) returns 6/24/2003

WeekdayAdd(ToDate("6/24/2003"), -2) returns 6/20/2003

If you have a date field named "Start Date" and that field has a value of 6/23/2003, then WeekdayAdd([Start Date], -2) returns 6/20/2003
WeekdaySub (Date d2, Date d1) Number Returns the number of weekdays in the interval starting with d1 and ending on the day before d2 (same as subtracting Dates, but the result is the number of weekdays instead of a Duration). It is the inverse of WeekdayAdd. WeekdaySub([Finish], [Start]) returns the number of weekdays between the dates in the Start and Finish fields.

WeekdaySub(ToDate("6/24/2003"), ToDate("6/20/2003") ) returns 2

Year (Date d) Number Returns the year number of the Date d. Year([Start Date]) returns the year of the date that appears in the Start Date field.

Year(ToDate("Jan 10, 2000")) returns 2000
Timestamps  (1 Function)  
Now () Date/Time Returns a Date / Time value representing the current moment. now() - [Date Created] returns the duration between the current moment and the date the record was created.
TimeOfDay  (4 Functions) 
Hour (TimeOfDay t) Number Returns the hour part of the argument t. The hour is in the range 0 to 23. Hour(ToTimeOfDay("3:04pm")) returns 15
Minute (TimeOfDay t) Number Returns the minute part of the argument t. The minute is in the range 0 to 59. Minute(ToTimeOfDay("3:04pm")) returns 4
MSecond (TimeOfDay t) Number Returns the millisecond part of the argument t. The millisecond is in the range 0 to 999. MSecond(ToTimeOfDay("3:04:01.344 pm")) returns 344
Second (TimeOfDay t) Number Returns the second part of the argument t. The second is in the range 0 to 59. Second(ToTimeOfDay("3:04 pm")) returns 0
WorkDates  (2 Functions) 
WeekdayAdd (WorkDate d, Number n) WorkDate Returns the date obtained by adding n weekdays to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/03/2003 since it counts 10/31/2003 as 1 day and 11/03/2003 (a Monday) as the second day. WeekdayAdd([Start],5) returns the date 5 weekdays after the date in the Start field.

WeekdayAdd(ToWorkDate(ToDate("10/31/2003")), 2) returns 11/03/2003

WeekdayAdd([Field A], [Field B]) where Field A is a field of type WorkDate and Field B is a field of type Numeric. Assuming that the value of Field A is 10/31/2003 and the value of Field B is 2, the formula will return 11/03/2003
WorkdayAdd (WorkDate d, Numeric n) WorkDate Returns the date obtained by adding n days to the date d. The calculation includes the date d as one of the n days. For example, adding 2 days to 10/31/2003 which is a Friday will give you 11/01/2003 since it counts 10/31/2003 as 1 day and 11/01/2003 (a Saturday) as the second day. WorkdayAdd([Order Date],7) returns the date seven days after the value in the Order Date field.

WorkdayAdd(ToWorkDate(ToDate("10/31/2003")), 1) returns 10/31/2003 while WorkdayAdd(ToWorkDate(ToDate("10/31/2003")), 2) returns 11/01/2003
Rounding and Truncating  (9 Functions) 
Ceil (Duration x, Duration y) Duration Returns the smallest multiple of the duration y which is greater than or equal to the duration x. Ceil(Days(3.5), Days(2)) returns Days(4)
Ceil (Number x) Number Returns the smallest integer greater than or equal to the number x. Ceil(3) returns 3
Ceil(3.4) returns 4
Ceil(-3.4) returns -3
Result Pages:  1  2    

We're glad you're interested in doing more with Quick Base!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quick Base with others in your company.

Your work email
Your company
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
You've made changes
Save
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quick Base often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quick Base finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quick Base needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table