Trim a Time

[James]

I have a Time displayed as HH:MM:SS:AM
I want to trim it to just show the Hour, how would I do this?

THanks

 

[fredg]

I have a Time displayed as HH:MM:SS:AM
I want to trim it to just show the Hour, how would I do this?

THanks

Set the control's Format property to
hh

 

[MarkD]

if it's a datetime field, hour([fieldname])

try hour(now()) in a debug window.

 

[James]

thanks!