Military Time Blues

[viperbyte]

Hi everyone. I need to be able to allow a user to enter a military time value in a form. I've tried placing a datetimepicker control but don't know how to make it so that the user will enter military time.



I'll need for the program to track the time an employee's logged in based on their military clock in and militrary clock out values entered by the way.

Is the datetimepicker control the way to go? If not, how do I go about this? Please.

[pbaldy]

I've never used a picker for time, so not sure if there's one that allows that. I use an input mask of this in a textbox:

00:00;0;_

[viperbyte]

Thanks for the input mask tip

[pbaldy]

No problem, and welcome to the site.

[Etoimos]

I'm trying to do the something very similar for a couple of fields on my form. I want the employee to enter in the time as hh:mm:ss in military time. When I try putting that into the Input Mask, it displays "hh:nn:ss" in the text box and does not allow me to actually enter a time in it. Any thoughts on what I'm doing wrong?

[pbaldy]

Did you try adding seconds to what I posted earlier?

00:00:00;0;_

[Etoimos]

Did you try adding seconds to what I posted earlier?

00:00:00;0;_

No, I just did and it worked. I guess I'm confused on what the ;0;_ part of that mask means.

[Etoimos]

Also, when I enter at time such as 22:34:15, it does not show the 15 seconds. It is there if I go back and click on the field again, it then shows the seconds, but the whole time has been converted to standard 12 hour time with an AM or PM attached to it. Moving away from the field again, it changes back to 24 hour time, but without showing the seconds.

[Etoimos]

It is also not saving the seconds into the underlying table. That is Formated as Short Time with the same Input Mask as the form.

[moke123]

to show the seconds I believe you need long time in your table and mask

[Etoimos]

to show the seconds I believe you need long time in your table and mask

That works to get it to show/record the seconds, but it kills the 24 hour/military format. If I enter in 23:45:30, the field gets converted to 11:45:30 PM.

[pbaldy]

Try a format on the textbox of

hh:nn:ss

[Etoimos]

Try a format on the textbox of

hh:nn:ss

That works for displaying military time in the form. The underlying table is still populated with an AM/PM format, but that might not be any issues as long as any reports I generate from that data is able to be displayed in military time.

[pbaldy]

The table is going to store the same thing either way, it's just a formatting issue (date/time values are stored as doubles, where the decimal portion is the time). Since I never let users directly into tables I never bother applying a format there, but you could if you wanted.

[Etoimos]

The table is going to store the same thing either way, it's just a formatting issue (date/time values are stored as doubles, where the decimal portion is the time). Since I never let users directly into tables I never bother applying a format there, but you could if you wanted.

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?