Converting a String Field to Military Time

[LAG813]

Hi,
I have been trying to convert a string field to add leading 0's for military time. Everything I have tried has failed. The latest formula tried was:
ToText({v_udf_Case_Record.entertime_or},"0000&quot

The formula editor, when checking for any errors, tells me that this statement has too many arguments...

What should I do next?
LAG813

 

[synapsevampire]

If it's a string field with a time format as in:

"11:23:58"

Convert it to time in a formula with:

time({v_udf_Case_Record.entertime_or})

and then you can place this formula in your report, right click it and select format field and set it for 24 hour.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com