hello.<BR>Does anyone know how to get every post that was posted yesterday, 2 days ago, 3 days, 4, 5 and six days ago?<BR><BR>This is todays posts:<BR>SQL = "SELECT * FROM MyTable WHERE Date = #"&date&"# ORDER BY Date "<BR><BR>But I also want to show yesterdays posts:<BR>What is the SQL for that.<BR><BR>And for all the posts that was posted 2 days ago.<BR>Whats the SQl.<BR><BR>Please help!<BR>