>>This query will return no result because LastSR is a date/time format and I'm not specifying the time. How can I compare only to the date of LastSR. DatePart does not have a date / time.
>>
>>select * from satfl where LastSR = '7/5/2000'
>
>Try this: select * from satfl where LastSR = #7/5/2000#
I get:
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '#'.