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

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

SELECT 
 Id as  [Post Link]
 ,CreationDate
 ,LastActivityDate
 ,DATEDIFF(month,CreationDate,GETDATE()) As MonthsAgoCreated
 ,DATEDIFF(month,LastActivityDate,GETDATE())  
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