Find records Older than a certain date?

I need to pull up a recordset with records older than 30 days from today's date. How do I do that?

here's my sql so far:

Code:

---

        sql2 = "SELECT TOP 10 URL, SubDate, Submitted FROM Sites WHERE Sites.SubDate < '" & strDat + 30 & "' AND  Sites.Submitted = '" & strNoSubmit & "' ORDER BY Category"

---

thanks

dont put an apostrophe around the date - if u r using an access database put # before and after the date.....

Also, are you trying to add 30 days to the date here:

Code:

---

WHERE Sites.SubDate < '" & strDat + 30 & "'

---

If so, I doubt that'll work. Use the DateAdd function:

Code:

---

DateAdd("d", 30, Date)

---

I stand corrected, it does work :o But I prefer the DateAdd function anyway. :)

well for me it didn't work. I'm not sure if the date + 30 really means to VB 30 days backwards from today. Do you?

nullus

the DateAdd function works better. You are right!

thanks