[AccessD] Datepart 24 hours

Mark,
In VB 6  I think H and h will return either 24 or 12 hour but not in Access.

I think
dteArrest = 
iif(datepart("h",[ArrestDT)>12,datepart("h",[ArrestDT]-12,("h",[ArrestDT]))
might work.

Bill
----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Sunday, January 28, 2007 8:29 PM
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

_________________________________________________________________
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

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