Pulling out certain data from a date/time field

[Lorimare]

I have a table that stores date/time asexample): 7/13/2004 2:06:04 AM

This is how the date/time is stored. Im trying to build a query and want to pull only certain parts of that field. What I need is the date and the hour only...so I need:
7/13/2004 2AM

Do I need to do a left or right of? such as Left([DateTime],11,19)

Thanks for the help.

 

[PHV]

Have you tried the Format function ?
Format([DateTime], "m/dd/yyyy hAM/PM")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244