Change military time to standard time 2

[cutpen]

How can I change military time which is in a field, e.g. 1800 to standard time e.g. 6:00pm?

 

[cutpen]

Thanks Rosemary, your have been a great help!

 

[FRONTSJ]

I am having the same problem only my field is a 'string'. When I use your formula it is asking for a number value in:

NumberVar T := {CONTHIST.ONTIME};

I'm assuming I need to convert this to a number field but I cannot find this formula anywhere.

 

[rosemaryl]

Dear Frontsj,

Try:

Numbervar T := ToNumber({CONTHIST.ONTIME});

Regards,
ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762