Selecting Part of a field when it's a date/time with BOTH data types

[Viv1]

Hi,

I am using a database which has a field called start_time in an Interview table, this is type: Date/Time. The problem is that data shows like this in the query result: 01/01/1900 10:30:00

I would like to extract only the time part but this doesn't seem to be working.

Any ideas so I can get the result to show: 10:30:00??

Thanks, Viv

 

[PHV]

Perhaps Format([start_time], 'hh:nn:ss') is what you need.

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

 

[Presterman]

Try the DatePart() Function

Dim TheDate As Date
Dim Msg
TheDate = InputBox("Enter a date:")
Msg = "Hour: " & DatePart("h", TheDate)
MsgBox Msg

 

[Viv1]

Hi,

Thanks for your suggestions....managed to get it working using the Mid function.