Q&A for scientific skepticism
SELECT * FROM Users WHERE [CreationDate] > DATEADD(DAY, -1, '2010-06-01') OR [CreationDate] < DATEADD(DAY, 1, '2010-06-01')