3 Replies Latest reply on May 27, 2009 7:32 PM by Dan Bracuk

    Stumped on grabbing a certain row in a table

    jasonfarran

      Okay, here's what I'm trying to do:

       

      I have a table that holds information based on dates. I want to be able to take the dates that are within the last 5 minutes...there could be say 4 rows that have a time within the last 5 minutes.  I need to somehow grab the row that was created first.

       

      Example of info that would be in the table:

      Name title 3:55pm

      Name title 4:25pm

      Name title 4:45pm

      Name title 4:50pm

      Name title 4:56pm

      Name title 4:57pm

      Name title 4:58pm

      Name title 4:59pm

       

      Say the time now is 5:00pm

       

      I want to be able to grab only the row that shows 4:56pm.

       

      Ive stumped myself here...my brain is fried.  I know how to grab all of the rows that are under 5 miutes ago, but not a specific one like this.

       

      Thanks for your help.