Contents
Data Types
The eServices Field Codes include the following data types:
Number
You use numbers in field code formulas in much the same way you would in other applications, such as Microsoft Excel. All arithmetic calculations are performed internally using floating point arithmetic (with the decimal point). Rounding occurs only during formatting.
When you write numbers in formulas, you can use scientific notation (for example, 12.34e2 is the same as0.1234).
The Operators table lists the operators that you can use with numbers. (Some rows show more than one symbol for the same operator. In these cases, the symbols are synonyms.)
Operator 
Description 
Example 
Result 

 
Unary Minus 
4 
4 
^ 
Exponentiation 
2^3 
8 

Multiplication 
2*3 
6 
/ 
Division 
8/2 
4 
Mod 
Modulus (Remainder) 
14 Mod 5 
4 
+ 
Addition 
2 + 3 
5 
 
Subtraction 
2 – 3 
1 
>
GT 
Greater Than 
2 > 3 
False 
>=
GE 
Greater Than or Equal To 
2 >= 2 
True 
<
LT 
Less Than 
2 < 3 
True 
<=
LE 
Less Than or Equal To 
2 <= 3 
True 
=
==
EQ 
Equal To 
2 = 3 
False 
<> != NE 
Not Equal To 
2 <> 3 
True 
: 
Format 
2 : “#.##”

2.00 
String
Use the String data type to represent textual data. When you write a string in a formula, you must enclose it in double quotation marks. For example:
 "The sixth sheik's sixth sheep's sick."
You can use the escape sequences shown in the Escape Sequences table to include special characters in a string, such as tabs or carriage returns.
It is also possible to use HTML tags in field codes.
Escape 
Translates to 

\a 
Alert (Bell) 
\b 
Backspace 
\f 
Form Feed 
\n 
Line Feed (Newline) 
\r 
Carriage Return 
\t 
Horizontal Tab 
\v 
Vertical Tab 
\' 
Single Quotation Mark 
\" 
Double Quotation Mark 
\\ 
Backslash 
The Operators and Strings table lists the operators that you can use with strings. All the comparison operators are case insensitive. (Some rows show more than one symbol for the same operator. In these cases, the symbols are synonyms.)
Symbol 
Meaning 
Example 
Result 

+ 
Concatenation 
"How" + "die" 
"Howdie"

>GT 
Greater Than 
"A" > "B" 
False

>=GE 
Greater Than or Equal To 
"A" >= "B" 
False

<LT 
Less Than 
"A" < "B" 
True

<=LE 
Less Than or Equal To 
"A" <= "a" 
True

=
==EQ 
Equal To 
"A" = "a" 
True

<> != NE 
Not Equal To 
"A" NE "B" 
True

Date and Time
Date/Time values in fieldcode formulas represent specific moments (for example, February 3, 2002, at 10:03:55 AM). The most common operations performed on Date/Times are comparisons (for example, <, =, and so on).
If you subtract two Date/Time values, the result is the number of days between them. See the Date/Time Example 1 table for examples.
Formula 
Result 

Date(2002, 11, 23) – Date(2002, 11, 22) 
1

Date(2002, 11, 22) – Date(2002, 11, 23) 
1

Date(2002, 11, 23) – Date(2002, 11, 23, 12) 
0.5

If you add (or subtract) a number to (from) a Date/Time, the result is the Date/Time moved forward (or backward) by that many days. See the Date/Time Example 2 table for examples.
Formula 
Result 

Date(2003, 11, 23) + 1 
20031124 00:00:00

Date(2003, 11, 23) – 0.5 
20031122 12:00:00

Boolean
Set Boolean values in fieldcode formulas to either True or False. You can use the True and False keywords to write a Boolean value explicitly, although this is rarely required. Comparison operators (for example, <, =, and so on) always yield Boolean results.
The Operators and Booleans table lists the operators that you can use with Booleans. (Some rows show more than one symbol for the same operator. In these cases, the symbols are synonyms.)
Symbol 
Meaning 
Example 
Result 

Not ! 
Unary Not 
Not False
Not True 
True
False

And
&& 
Logical And 
False And False
False And True
True And False
True And True 
False
False
False
True

Or  
Logical Or 
False Or False
False Or True
True Or False
True Or True 
False
True
True
True

XOr 
Logical Exclusive Or 
False XOr False
False XOr True
True XOr False
True XOr True 
False
True
True
False

=
==
EQ 
Equal To 
True = False 
False

<> != NE 
Not Equal To 
True <> False 
True

Feedback
Comment on this article: