Military Time Blues

[moke123]

I set the table field to long time with a mask of long time. I also set the control on the form to a long time format with a longtime mask and it works for me.
Both show 24 hr time.



edit Just noticed the OP was 8 years ago and thought I was answering an old post for a minute.
You should have started a new post and reference this one if needed.

[pbaldy]

Okay. On my subsequent forms I would still be able to apply a format that would show the time on them in military time even if the time in the table was standard time correct?

Yes, as I said it's all just formatting. No matter the format, the value is saved as a double. For example, this moment in time is:

?cdbl(now())
43934.5880671296

The integer portion is the number of days since the seed date, which if memory serves is 1/1/1900 or something like that. The decimal portion is the fractional value of the time. 6am is .25, noon is .5, etc. No matter what you might see in the table or on a form/report, what's stored is 43934.5880671296 . You can format it any way you want on forms/reports, and they can show different formats as needed. By the way, if you only enter/save a time value, it would be saved like 0.5880671296.

[pbaldy]

Sorry moke, your post was on page 2 and I didn't realize there was another page.

[moke123]

No problem. I thought this was an 8 years old post cause you answered it back then too.

[Etoimos]

Thanks guys.