Format d/M/YY date into DD/MM/YYYY

[denko]

I created a formula "As of " + Totext({TableName.Date})
it displays As of 7/3/02.
How can I make it to show up as - As of 07/03/2002 ?
Thanks

 

[rogar]

Totext({TableName.Date},"dd/MM/yyyy&quot

 

[denko]

Thanks

 

[rogar]

These things can be found in CR Online Help. Just press F1 or click in the "?" button. In the Help dialog, select the Index tab and type what you are looking for (e.g. "ToText&quot in the "keyword to find" box and click the "Display" button.