[AccessD] Datepart 24 hours

Gustav Brock Gustav at cactus.dk
Mon Jan 29 02:27:16 CST 2007


Hi Mark

Well, one day is 24 hours.
Divide by 2 to get AM/PM.

/gustav

>>> markamatte at hotmail.com 29-01-2007 05:29:28 >>>
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




More information about the AccessD mailing list