Extract a part of a date or time value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Format([YourDate]-Int([YourDate]),"hh:nn:ss")

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