Convert 5/31/2007 to 0507

[jms493]

how can I do this using crystal forumlas?

 

[lbass]

If it's a date datatype, just right click on it->format field->date->customize->select month: 03-> day: none-> year: 99->first separator: none-> second separator: none.

If it's not a date, you need to show how the field displays in all its variations.

-LB

 

[Madawc]

If it's a date, you could also use

ToText({Your.Date}, "MMyyMM")

Lots of interesting things you can do with ToText, worth exploring.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[IdoMillet]

Madawc probably meant "MMyy" instead of "MMyyMM"

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com