Crazy SQL scripts involving DATELINE and DATE()

[Hwulex]

Thanks for the suggestion, but I still don't think that will work, for the same reason I post above. AFAIC tell, that's the same logic as I was trying to use first time.
The problem is, I need to retrieve all posts from the previous month to this one, and I can't see a short way of doing it without much code writing.


I understand what you're saying about the quoted code. I never expected it to work, was just a wild stab in the dark out of desperation.
Btw, the p.dateline that you refer to is valid, but I haven't quoted the rest of the query. p is an alias for the post table which is set earlier in the query.

Cheers.