formatting date in Crystal Report formula

[Flupke]

How can I format a date in a Crystal Report formula, like I would do in the Visual Basic expression
Format(date, "dd/mm/yyyy&quot.
This doesn't seem to work in CR. What is the alternative using Crystal syntax and the alternative using Basic syntax?

Many thanks,

Michel

 

[synapsevampire]

Just right click the date and select Format Field->Date/time->Customize->Date or Time and set it however you'd like.

You can convert it to text and format it too, as in:

totext({@Order Date},"dd/MM/yyyy&quot

-k

 

[chelseatech]

Synapsevampire is right.

It pays to rememebr that the mask in the ToText function is case sensitive. Use MM for months and mm for minutes.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm