Change Date Format on Multiple Records

[illini]

I have a table with a Date field in the following format: "1:33:00 PM". I would like to do an Update query on the table to change the date to military time: "13:33".

Any ideas? -illini

 

[simma]

Keep in mind that a date/time field is exactly that. It is a 64 bit double; with a magnitude for the date and a magnitude for the time. While you may have specified a long time format so that you see "1:33:00 PM" does not change the fact that this time and any time in Access also contains the date. You simply use the format feature to show only the time.

So given that information, changing to a military date format does not require an update query or any code at all. Simply change the format of this date/time field to short time and you will be using 24 hour military time.

 

[thornmastr]

I have no idea what is going on with tek tips, but sima did not write the previous reply. Twas me; so don't yell at poor sima. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com