Examples of Formula and Combination fields
From Microsoft Office Outlook 2003
Examples of Formula and Combination fields
| What you want to show | 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 .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/97 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] [Car Phone] | (555) 555-1234 |
| A description of a field combined with the field itself. (Combination field) | Task Due: [Due Date] | Task Due: 3/5/97 8:00:00 A.M. |