24 Hours Time

[IgorB]

I am trying to insert Time to TEXT field by using Format(Now(),'hh:nn:ss AMPM') like:

DoCmd.RunSql "Insert into TableTimes(MyTime) values(Format(Now(),'hh:nn:ss AMPM')".

With Morning Time I am OK: 08:14:23 AM.
Afternoon Time like 01:20:32 PM should look like 13:20:32 PM!!!!!

How should I store time like this 13:20:32 PM (mean 24 hours format) in TEXT FIELD?

Thanks.

 

[namliam]

AM/PM = 12 hours clock

00 - 23 hours = 24 hours clock.

You want to mix up the 2....

Regards

 

[RV]

The format is working OK as you're using the twelve hour clock format.
13:20:32 PM doesn't exist....

RV

 

[IgorB]

Thaks a lot Namliam.
You are right. Without AM/PM it allows me to store with 24 hours format!!!

 

[Mile-O]

One question: why would you want to store the time as a text value?

It saves space to store it as a Date/Time data type (only 8 bytes) whereas the 24 hour clock as text will take up 18 bytes.

You only need to format for displays in queries, forms, and reports.

 

[RV]

Mailman

Thaks a lot Namliam.
You are right. Without AM/PM it allows me to store with 24 hours format!!!

No thanks.
BTW, I'm definitely NOT Namliam the Mailman from Amsterdam

RV

 

[Mile-O]

I'm definitely NOT Namliam the Mailman from Amsterdam

I think he was actually responding to namliam's post prior to yours.

 

[RV]

I think he was actually responding to namliam's post prior to yours.

Actually, I think I wasn't thinking or thinking too much missing "Mailman's" response (he beat me by a whole minute..)

RV

 

[IgorB]

To Mile-O-Phile.
Your Location shows Glasgow, Scotland in Russian letters.
Are you from there?