is
 
Function Name
Arguments
Result Type
Explanation
Examples
 
Binary Operators (act on multiple values)  (32 Functions) 
& <any> u, <any> v Text Returns a text value that is the concatenation of u and v. Use this operator to link strings of characters together in a formula text field. 

If u or v is not a text value, QuickBase automatically inserts the function ToText() to convert the value to text before concatenating it.

Does not support User or UserList.
"abc" & "def" returns "abcdef"
"abc" & 5 returns "abc5"
[First Name] & " " & [Last Name] concatenates the values in the First Name and Last Name field with a space in between them.
* Duration d, Number n Duration Returns a new Duration that is the given Duration d repeated n times. In other words, it's the duration multiplied by the number n. Weeks(2) * 3 returns 6 weeks
* Number m, Number n Number Returns the product of m times n. [Price] * [Number of Units] multiplies the value in the Price field by the value in the Number of units field.
-3 * 4 returns -12
0.5 * 5 returns 2.5
* Number n, Duration d Duration Returns a new Duration that is the given Duration d repeated n times. In other words, it's the duration multiplied by the number n. 3 * Days(2) returns 6 days
+ Date d, Duration x Date Returns the date that is after date d by the duration x. x is truncated to a whole number of days. [Start Date] + [Duration] returns the date you get by adding the value in the Duration field to the date in the Start Date field.
ToDate("Jan 1, 2000") + Days(2) returns Jan 3, 2000
+ Date/Time t, Duration x Date/Time Returns the Date/Time that is after Date/Time t by the duration x. [Call Time] + [Review Period] returns the date and time that follows the date/time in the Call Time field by the duration listed in the Review Period field.
+ Duration d, TimeOfDay t TimeOfDay Returns the TimeOfDay that is after TimeOfDay t by the duration x. ToTimeOfDay("2 pm") + Hours(22) returns 12 pm
+ Duration x, Date d Date Returns the date that is after date d by the duration x. x is truncated to a whole number of days. Days(2) + ToDate("Jan 1, 2000") returns Jan 3, 2000
+ Duration x, Date/Time t Date/Time Returns the Date/Time that is after Date/Time t by the duration x. [Hours Worked] + [Start Time] returns the time of day resulting from adding the value in the Hours Worked field to the time in the Start Time field.
+ Duration x, Duration y Duration Returns the duration that is the sum of x and y. Days(1) + Days(2) returns 3 days
+ Number m, Number n Number Returns the sum of m and n. 3 + 4 returns 7
[Subtotal] + [Tax] returns the sum achieved by adding the value in the Subtotal field to the value in the Tax field.
+ TimeOfDay t, Duration d TimeOfDay Returns the TimeOfDay that is after TimeOfDay t by the duration x. [Start Time] + [Hours Worked] returns the time of day resulting from adding the value in the Hours Worked field to the time in the Start Time field.
- Date d, Date e Duration Returns the duration between dates d and e. [Actual Date Completed] - [Forecast Date] returns the duration between the date in the Actual Date Completed field and the one in the Forecast Date field.

ToDate("Jan 3, 2000") - ToDate("Jan 1, 2000")  returns 2 days
- Date d, Duration x Date Returns the date that is before date d by the duration x. x is truncated to a whole number of days. [Finish] - [Duration] returns the date you get by subracting the value in the Duration field from the date in the Finish field.

ToDate("Jan 3, 2000") - Days(2) returns Jan 1, 2000
- Date/Time t, Date/Time u Duration Returns the duration between Date/Time values t and u. [Created] - [Time/Date Resolved]
- Date/Time t, Duration x Date/Time Returns the Date/Time that is before Date/Time t by the duration x. [Event Start] - [Days to Prepare] returns the Date and time that precedes the event start by the number of days in the Days to Prepare field.
- Duration x, Duration y Duration Returns the difference of x and y. Weeks(1) - Days(2) returns 5 days
Days(1) - Weeks(1) returns -6 days
- Number m, Number n Number Returns the difference of m and n. 7 - 3 returns 4
-7 - 2 returns -9
- TimeOfDay t, Duration d TimeOfDay Returns the TimeOfDay that is before TimeOfDay t by the duration d. [Meeting Start] - [Hours of Prep] returns the time that precedes the Meeting Start time by the number of hours listed in the Hours of Prep field.
- TimeOfDay t, TimeOfDay u Duration Returns the duration between TimeOfDay t and TimeOfDay u.

The result may be positive or negative depending on whether t is after or before u.
[End] - [Start] returns the duration you get by subtracting the time value in the Start field from the value in the End field.
ToTimeOfDay("3pm") - ToTimeOfDay("2pm") returns 1 hour
ToTimeOfDay("2pm") - ToTimeOfDay("3pm") returns -1 hour
/ Duration x, Duration y Number Returns the number of times that Duration y divides into x. Weeks(1) / Days(1) returns 7
/ Duration x, Number n Duration Returns a new Duration that is x divided by n. Weeks(2) / 2 returns 1 week
/ Number m, Number n Number Returns m divided by n. 6 / 4 returns 1.5
< <any> x, <any> y Boolean Returns true if x is less than y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 < 4 returns true
4 < 3 returns false
"abcdef" < "gh" returns true
<= <any> x, <any> y Boolean Returns true if x is less than or equal to y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 <= 4 returns true
"abcdef" <= "gh" returns true
<> <any> x, <any> y Boolean Returns true if x is not equal to y, otherwise returns false.  

x and y must be the same type.

As with most other functions, null argument values produce a null result, so it is not possible to test for null with this operator. To test for null, use IsNull() instead.
(3 / 4 <> 0.75) returns false
= <any> x, <any> y Boolean Returns true if x is equal to y, otherwise returns false.

x and y must be the same type. 

As with most other functions, null argument values produce a null result, so it is not possible to test for null with this operator. To test for null, use IsNull() instead.
(3 / 4 = 0.75) returns true
> <any> x, <any> y Boolean Returns true if x is greater than y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
3 > 4 returns false

[Actual Completion Date] >= [Projected Completion Date] returns true if the value in the the Actual Completion Date field is greater than the date in the Project Completion Date field.

Weeks(1) > Days(6) returns true
>= <any> x, <any> y Boolean Returns true if x is greater than or equal to y, otherwise returns false.  

x and y must be the same type.

For Numbers, the comparison is numerical.
For Durations, the comparison is done using length of time represented.
For Text, the comparison is done by alphabetical sort order.
For Dates and Date/Time values, the comparison is done by chronological order.
For Booleans, false is less than true.
[Actual Completion Date] >= [Projected Completion Date] returns true if the value in the the Actual Completion Date field is greater than or equal to the date in the Project Completion Date field.

ToDate("Jan 1, 2000") >= ToDate("Feb 1, 1999") returns true
^ Number m, Number n Number Returns m raised to the nth power. 2 ^ 3 returns 8
9 ^ 0.5 returns 3
2 ^ -3 returns 0.125
and Boolean a, Boolean b Boolean Returns true if a and b are both true, otherwise returns false.

Use this operator to link conditions together.
(true and false) returns false

[Decision - Technical Lead]="Approved" and
[Decision - Project Manager]="Approved" and 
[Decision - Project Sponsor]="Approved" 
returns true if all three fields contain the value "approved"
or Boolean a, Boolean b Boolean Returns true if either a or b is true, otherwise returns false. (true or false) returns true
SUMMARY
  Category Number of
Functions
 
    Graph
Binary Operators (act on multiple values) 32
  Totals (1 group) 32

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



This report will be saved as a personal report (only you can view it)
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