storing military times

[Lifeseeker]

Hi,

I am using Access 2003.

I'm creating a database and one of the fields in the database is to store Military Time.

The datatype is set to "date/time", but do I need to change anything in the Format for the field to actually get it to store and show times in Military format?

comment/help much appreciated

 

[John Big Booty]

Perhaps this article will help. My understanding is the 12 hour and 24 hour times are stored in exactly the same way, the difference is in how they are formatted for display purposes.