time display

[neskin]

Hi,
I have a string field '2300 - 0559' .How to display in crystal xi 2300 - 0600

thank you in advance
nat

 

[Madawc]

For the string you give, you could get the desired result with

Left({field}, 6) & ToText(Truncate(ToNumber(Right({field}, 4), -2))

This separates the last four characters, turns them into a number and then truncates them to the nearest hundred.

It helps to give your Crystal version.

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

 

[lbass]

Try:

Left({table.field}, 7) + ToText(-int(-val(right({table.field},4))/100)*100,"0000")

-LB