>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,
Shane Murdoch