[AccessD] Military Time

Virginia

How will you know? If they enter 1:00, do they mean AM or PM?

If you have another field for AM/PM, then you can easily convert.

Check the AMPM field on BeforeUpdate.
  If AM, do not allow the time field to exceed 12:00.
  If PM, and time field is < 12:00, use the DateAdd to add 12 hours.
  If they enter 12:00 exactly, you should probably popup a window asking
them to clarify if they mean noon or midnight.

FYI - http://www.spacearchive.info/military.htm

Regards,

Bob Gajewski


 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Wednesday, April 27, 2005 09:30 AM
To: accessD at databaseadvisors.com
Subject: [AccessD] Military Time

I need to format a Time field so they always enter time as 2400, 2330, etc.
If they enter 1:00 I want it to change to (1300) the 24 hour time.
How do I do that?

 

Virginia

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com