I need to get a regular time value from a military time 3

[BobMcConnell]

the values are 1000
1400
1600

 

[bdreed35]

If your field is non numeric, create a formula like this to convert it to Time type:

Time (val(Left({table.field},2)), val(Right({table.field},2)), 0)

If it is numeric, you can adjust the formula like this:

Time (val(Left(ToText({table.field},0,""),2)), val(Right(ToText({table.field},0,""),2)), 0)

~Brian

 

[bdreed35]

I forgot to mention that once you have converted it to a Time type, you can format it in what ever Time format you want.

You can do this by placing the field on your report, Right clicking it, and choosing Format field.
Click the Time tab.
You can use one of the preset formats or click the customize button to create a custom format.

~Brian

 

[BobMcConnell]

Brian,

Thank you for your help - especially so quickly. When I paste in this formula (the field is a number) and replace table.field with the fieldname I get the message "The field name is not known". What am I doing wrong?

 

[bdreed35]

Try deleting each instance of "{table.field}" from the formula, and add the field from the Field list by double clicking it in the Field list in the Formula Editor. Make sure that the cursor is where you want to the field to end up before you double click.

If this doesn't solve the problem, please post your formula.

~Brian

 

[BobMcConnell]

BRIAN,

THANKS FOR THE HELP BUT WHEN I PLUG THE FIELD NAME WHICH IS A NUMBER INTO THE FORMULA I GET AN ERROR THAT SAYS THE FIELD DOES NOT EXIST. ANY IDEAS

 

[BobMcConnell]

SORRY,

DIDN'T SEE YOUR LAST MESSAGE - HERE IS THE FORMULA

Time (val(Left(ToText({{vSubjectAppointment.BeginTime}},0,"&quot,2)), val(Right(ToText({{vSubjectAppointment.BeginTime}},0,"&quot,2)), 0)

 

[BobMcConnell]

I posted the formula, but it's still not working!

 

[lbass]

You have double curlicue brackets--try removing them as in:

Time (val(Left(ToText({vSubjectAppointment.BeginTime},0,"&quot,2)), val(Right(ToText({vSubjectAppointment.BeginTime},0,"&quot,2)), 0)

-LB

 

[vidru]

Just for kicks, here's another:

Time(int({vSubjectAppointment.BeginTime} / 100), {vSubjectAppointment.BeginTime} mod 100, 0)

-dave