[AccessD] Datepart 24 hours

I think, but can not test at the moment that you would use:
 
DatePart("hh",[ArrestDT])

Note the "hh" instead of "h" format specifier.

Bobby



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Sunday, January 28, 2007 11:29 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Datepart 24 hours

Hello All,

In using DatePart("h",[ArrestDT]) I get the 24 hour clock...is there a 
variation of this formula to get a 12 hour clock...or do I need if 
statements to calculate when over 12 and account for 00?

Thanks,

Mark A. Matte