Finding the date

• samcneal

  Old Hand

  Points: 316

  More actions

  February 14, 2005 at 11:38 am

  #65988

  Does anyone knows how I can find the first time a record input into the system?

  I have the following:

  Select * from status

  where datefirstentered > datecompleted

  but this is not guaranteed to pull the first time the record was entered into the system Anyone has any other ideas?

  Thanks

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  February 14, 2005 at 11:58 am

  #542136

  SELECT TOP 1 DateFirstEntered FROM Status

  WHERE DateFirstEntered > DateCompleted

  ORDER BY DateFirstEntered ???

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net