Extract a part of a date or time value

J

Jez

Hi,

If I have a date and time in as a value (21/Nov/2005 14:57:00) How can I
split the time out? I am looking to filter any that are greater than 17:00
regardless of the date.

Thanks,
Jez
 
K

KARL DEWEY

Format([YourDate]-Int([YourDate]),"hh:nn:ss")

17:00 is the decimal 0.708333333333333 so greater or equal for your
criteria.
 
Top