all posts you have edited with their date and activity information

0

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

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results