

& 
<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 