VegasL - Saturday, November 11, 2017 10:44 PM
This is a datetime value, neither a string nor date value, constrain the search accordingly, i.e. WHERE [date] > CONVERT(DATEDIME,'2014-12-31 23:59',126)
AND [date] < CONVERT(DATEDIME,'2016-01-01 00:00',126)
😎