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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.