TRANSFORM

Converts date and numeric data to character strings. For use in expressions where you need to combine text and date/numeric fields into one statement.

Reporting Area(s):

General

Required Parameters:

1. Field to convert (i.e. cobegdate, rgcrsefee)

Optional Parameters:

2. Format Code, entered in quotations:

"$$$,$$$.99"= applies currency format

"Y"= converts logical True (.T.) and False (.F.) values to Y and N

"@T"= trims leading and trailing spaces

Example(s):

TRANSFORM(cobegdate) converts course begin date to character string.

TRANSFORM(rgcrsefee,"$$$,$$$.99") converts registration fee amount to character string and formats as currency (e.g. $1,250.00).

Notes:

Standard FoxPro Function

 

Related Topics