FORMULA LANGUAGE


Examples: @Text
1. This example returns 123.45.
2. This example returns $800.00 if the value in the Sales field is 800.
3. This example returns 8.00E+02.
4. This example returns 8.00E+02 and -6.00E+02 in a list.
5. This example returns 04/11/93 10:43 AM.
6. This example returns 04/11.
7. This example returns 10:43:30 AM.
8. This example returns 04/93 10:43 AM.
9. This example returns the rich-text Body field stripped of attachments and formatting.
10. To convert a number date (in the ShipDate field) into a written date, you can use the following code. If ShipDate contains [08/31/2002], the result is "August 31, 2002."

See Also