SQL query to only show newer records in a table by stored date

[hallm]

I want to be able to list only the newest six or seven records in my table by date.&nbsp;&nbsp;(Not by newest keyed in, sometimes we backdate and prodate records).&nbsp;&nbsp;How can I modify my sql statement to do this?&nbsp;&nbsp;Or do I have to do this another way?&nbsp;&nbsp;My current statement is below.<br><br>set sleuth = db.execute(&quot;SELECT * FROM cybersleuth WHERE publish = true ORDER BY date desc, time desc&quot