Stack Exchange
log in help

all posts you have edited with their date and activity information

4

Please login or register to vote for this query.

(click on this box to dismiss)

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

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

SELECT 
 Id as  [Post Link]
 ,CreationDate
 ,LastActivityDate
 ,DATEDIFF(month,CreationDate,GETDATE()) As MonthsAgoCreated
 ,DATEDIFF(year,LastActivityDate,GETDATE())  
FROM 
 Posts
WHERE
 LastEditorUserId = '##UserId##' AND
 OwnerUserId != '##UserId##'
Order By LastActivityDate asc
view current version

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results