Reall simple Date/Time converstion question 1

[aaronlglover]

Hey Guys,

I am sure the answer to this is very simple I just can't find it anywhere on the net. What is the function in Jet SQL to convert a date time (07/13/2009 13:30:00) to just show the time (13:30)

Thanks

 

[PHV]

TimeValue([yourDateTime field])
or
Format([yourDateTime field], "HH:NN")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[aaronlglover]

Thanks PHV,

Worked perfect.