CONVERT TIME STRING FIELD

[mamarockstar]

I have 2 report fields - start_time and end_time. Both of these fields are string fields. Right now they output the time like this: 09:00 AM. How can I change the format?

thanks

 

[Turkbear]

Hi,
Change it how?

Where do they come from and how are they defined it that source?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

A formula field with Ctime({your.field) should turn it into an actual time. Then you can change the display by right-click on the formula field and 'Format Field'. Or else create a second Formula Field that displays the first using ToText, which has interesting options for date and time.

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.

Also please don't use block capitals, it counts as SHOUTING.

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