Find records Older than a certain date?

[jesus4u]

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:

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

thanks

[xhomerx]

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

[nullus]

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

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

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

DateAdd("d", 30, Date)

[nullus]

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

[jesus4u]

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?

[jesus4u]

nullus

the DateAdd function works better. You are right!

thanks