DECLARE @date1 date = '01-01-18'; DECLARE @date2 date = '...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Patents Meta

Q&A about the site for people interested in improving and participating in the patent system

DECLARE @date1 date = '01-01-18';
DECLARE @date2 date = '12-31-18';
select distinct count(DisplayName) from users 
  join posts 
  on users.Id = posts.OwnerUserId
  where (posts.PostTypeId = 1) and (posts.CreationDate < CAST('2018-01-01' AS DATE) or posts.CreationDate > CAST('2018-12-31' AS DATE))
-- between @date1 and @date2

Enter Parameters

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