| 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. |
