[AccessD] Datepart 24 hours

Mark A Matte markamatte at hotmail.com
Sun Jan 28 22:29:28 CST 2007


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

_________________________________________________________________
Search for grocery stores. Find gratitude. Turn a simple search into 
something more. 
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG




More information about the AccessD mailing list