I have a table that has a datetime field called TimeOut. I need to update a record where RadioEntity = 'something' and Status = 'Out' and TimeOut = Today's date
I am not sure how write compare for just today's date... here is what i have so far.. thanks in advance for the help
SET Status = 'In', TimeIn = '2015-04-07 11:07:35.000'
where RadioEntity = '62 - Kincaid, Mark' and Status = 'Out' and TimeOut =