Format date issue 1

[munchen]

I have the following date formula:

minimum({tblA.date}) & ' - ' & maximum({tblA.date})

This is currently displaying data like so:

01/01/2007 - 30/06/2007

How can I make the field display like so:

01/01/07 - 30/06/07

By making year yy instead of yyyy?

 

[Madawc]

Try

ToText(minimum({tblA.date}), "dd/MM/yy") & ' - ' & ToText(maximum({tblA.date}), "dd/MM/yy")

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.


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

 

[munchen]

Madawc

Worked perfectly. Many thanks!