Skip to content

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 ​

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

CTOD
DTOC
STR
VAL