Military time (24-hour clock)

DenSter

Hello all,

Is there an easy way to have Navision display a time field in military time format, also known as the 24 hour clock, regardless of the system setting? So instead of 2:00:00 PM, I want to see 14:00:00.

Thanks,
Daniel

eromein

sure... Just open the help on the FORMAT statement.

Btw, Everybody (except for the English) in Europe uses this time format. And you know what the best part of this time system is? You will never sit in a bar at 10:00 in the morning waiting for your date!

DenSter

I know about the FORMAT statement in C/AL code, and I know how to accomplish this on forms. The part that I don't know is if there is an easy way to do this in the table.

The issue here is that Americans are used to the AM/PM format, so all their computers are set to display those, and nobody's willing to have to change that setting just for Navision. My customer wants to see 'military time' on selected fields only, and I'd like to know if you can set this on the table, so I don't have to do it on all the forms associated with those fields.

GoMaD

You can always use the 'AutoFormatType' and the 'AutoFormatExpr' properties on the fields of your table.

You can use this to adjust the formatting of this field.

Greetings

DenSter

GoMaD wrote:

You can always use the 'AutoFormatType' and the 'AutoFormatExpr' properties on the fields of your table.

Nope, those don't work on a Time type field.

GoMaD

You can always adjust your regional settings of the PC.

But that is system wide of course.

DenSter

Like I said before:

DenSter wrote:

The issue here is that Americans are used to the AM/PM format, so all their computers are set to display those, and nobody's willing to have to change that setting just for Navision.