Using general date format & want to show up as military time

D

denilynn

I'm using the "general date" format and would like the pm
times to show up as military time, preferable without the
seconds displaying also. Is this possible? Thank you in
advance for your help!
 
J

John Vinson

I'm using the "general date" format and would like the pm
times to show up as military time, preferable without the
seconds displaying also. Is this possible? Thank you in
advance for your help!
Click to expand...

An Access Date/Time value is stored as a number - it's not stored in
"general date" format or any other format! The format is applied when
you display the number.

Just set the Format property of the field, or of the Form or Report
textbox in which you're displaying the field, to

hh:nn

to display as 16:37. If you want it to appear as 1637 just leave out
the colon.
 
Top