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 ​
- Field to convert (i.e. cobegdate, rgcrsefee)
Optional Parameters ​
- 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