Gets all posts you have edited and
>Gets the difference in months, between when they were created and when they were last active.
>Gets the difference in months, between when they were created and when they were **last edited**.
This could help you figure how close you are to Excavator and Archeologist
Q&A about the site for administrators, end users, developers and designers for Craft CMS
SELECT TOP 100
Id as post_id
,LastActivityDate As last_active
DATEDIFF(month,LastActivityDate,GETDATE()) > 6
/* As always I'm doing this as a learning exercise and some of my findings
The column alias cannot be referenced in the select portion of the clause: