Latest 2 days but not restricted 2 days from now

[Karl Blessing]

I have this query (which is called from ASP)

RS.Open "Select PostDate, PostTopic, Post, Signature from Postings order by PostDate DESC", Conn, 1, 3

I want to change that query to only pull back the latest 2 days of records, I tried to do latest records 2 days from now, but that didnt return anything, so I want to return least something so I am wondering how to return the latest 2 days of postings from the recordset. Karl Blessing aka kb244{fastHACK}

 

[MichaelRed]

Where [Date()] - [PostDate] <= 2.

MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over