Time function help

• actinicblue

  Mr or Mrs. 500

  Points: 575

  More actions

  November 13, 2001 at 6:37 pm

  #158045

  Okay now I'm stumped, my last posting was a little premature, my bad. But I don't quite no how to get this one. I have a field called LogTime which holds the time a certain event happened. I want to count the number of times the difference between entries in the field were 4 minutes or more. I can't quite figure out if there is something like Datediff specifically for time only. I tried using

  Datediff(minute, Logtime, Getdate) > 4 but that returns an error. I just can't find the right syntax. Any ideas

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  November 13, 2001 at 7:28 pm

  #420080

  have you looked in the bol?

  try

  Datediff(mi, Logtime, Getdate())

  
  Cursors never.
  DTS - only when needed and never to control.