Lotus Domino Designer 8.5 Help

FORMULA LANGUAGE

Examples: @Text
1. This example returns 123.45.

@Text(123.45)

2. This example returns $800.00 if the value in the Sales field is 800.

@Text(Sales;"C,2")

3. This example returns 8.00E+02.

@Text(800;"S")

4. This example returns 8.00E+02 and -6.00E+02 in a list.

@Text(800 : (-600);"S")

5. This example returns 04/11/93 10:43 AM.

@Text(@Now)

6. This example returns 04/11.

@Text(@Now;"D1S0")

7. This example returns 10:43:30 AM.

@Text(@Now;"D1S1")

8. This example returns 04/93 10:43 AM.

@Text(@Now;"D3T1")

9. This example returns the rich-text Body field stripped of attachments and formatting.

@Text(Body)

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

@If( @IsTime(ShipDate);

@Text(@Select(@Month(ShipDate); "January"; "February"; "March"; "April"; "May"; "June"; "July"; "August"; "September"; "October"; "November"; "December")) + " " +

@Text(@Day(ShipDate)) + ", " + @Text(@Year(ShipDate));

"No date given")

See Also

@Text

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary