Calculated Field Operations

In the following example, a date field has two operations performed on it:

The date is replaced by the quarter of that date, e.g. "January 14, 2008" becomes "Q1 2008".
Text is added to the beginning of the field, e.g. "Q1 2008" becoming "Quarter: Q1 2008".

Linked Graphic

Any number of operations can be added here, and they're performed sequentially - one after the other - so the second operation gets the result of the first to work on.

Linked Graphic

Most of the operations available here are self-explanatory.

Operation	Action/Example
Add text to the end
Add text to the beginning
Convert to upper-case	"`Smith, Dale`" becomes "`SMITH, DALE`"
Convert to lower-case	"`Smith, Dale`" becomes "smith, dale"
Search & replace	Recursive replacement of text values; does not allow the replacement value to contain the source value.
Limit length of the text	If the text is longer than the number of characters you specify, it will be chopped off at the length you designate here.
Add years to a date	For all "Add XXX to a date", if the date is blank, no action is taken.
Add months to a date
Add weeks to a date
Add days to a date
Day of week	e.g. "Monday"
Week of year
Month of year
Quarter of year
Year portion of date
Fiscal month of year
Fiscal quarter of year
Fiscal year of date
Add/subtract number
Multiply
Divide
Round a number	`14.5678`, `2` becomes `14.57` `143.56`, `-2` becomes `140`.
Truncate a number	`14.5678`, `2` becomes `14.56` `143.56`, `-2` becomes `140`.
Choose text based on the field being TRUE or FALSE	All three of these take a wide view of "True" and "False": "`1`", "`T`", and "`Y`" are TRUE, "`0`", "`N`" and "`F`" are FALSE.
Choose a number based on the field being TRUE or FALSE
Choose a date based on the field being TRUE or FALSE
Date portion of a date/time value
Time portion of a date/time value