>What is the correct syntax for extracting the hours and minutes from a datetime variable?
>Thanks.

The following functions can be used to access the different parts of a datetime variable:

YEAR()
MONTH()
DAY()
HOUR()
MINUTE()
SEC()

Hope this helps,