Can somebody please advice me on the correct syntax of a sql query asking 

the latest day's records from a recordset? The query requests data from 2  

different tables.

Unless you have some kind of timestamp on your records, I don't believe you

could get records that were inserted within a specified date range.  I could

be wrong on this, perhaps you could do something fancy with the transaction

log, but it would seem to me to be much easier to always have some type of

timestamp on each record and make sure you always include that in any

inserts you perform.



Peter



-----Original Message-----

From: Nick [mailto:ektorjr@h...]

Sent: Monday, March 19, 2001 6:21 AM

To: ASP Web HowTo

Subject: [asp_web_howto] last date's records query





Can somebody please advice me on the correct syntax of a sql query asking

the latest day's records from a recordset? The query requests data from 2

different tables.