Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Examples of Formula and Combination Fields

Display

Custom field

Result in custom field

Number of days since the item was received. (Formula field)

DateValue (Now())-DateValue ([Received]) & " Day(s)"

6 Day(s)

Description of a meeting or appointment in Calendar. (Formula field)

"This meeting occurs " & [Recurrence Pattern] & " in " & [Location]

The meeting occurs every day from 12:00 P.M. to 1:30 P.M. in room 1231

Amount to be charged for a phone call recorded in the Journal at $0.75 a minute. (Formula field)

IIF ([Entry Type] = "Phone call" , Format ([Duration] * .75, "Currency"), "None")

$1.50

Description of a Message Flag. (Formula field)

IIF ( [Flag Status] = "2", [Message Flag] & " " & [Due By],"")

Follow up 3/5/2009 8:00:00 A.M.

The first phone number recorded for a contact, in order of appearance in the formula. (Combination field)

[Business Phone] [Business Phone 2] [Home Phone] [Home Phone 2] [Cell Phone]

(555) 555-1234

A description of a field combined with the field itself. (Combination field)

Task Due: [Due Date]

Task Due: 3/5/2009 8:00:00 A.M.

Show:
© 2015 Microsoft