WendellB (11/16/2016)
Is there a reason you posted this in the Microsoft Access forum? The responses deal with dates the way SQL Server handles them. Access does things a bit differently, so if you are working with Access, and the fact that you mention filters suggest you may be, then you need to use the Access Date() function. I should note that if you are using an Access ADP solution, which is not supported in current versions, then the SQL date functions are appropiate. Can you clarify you environment please?
Hello, sorry so late, yes I use Access ADP solution and connection with SQL2008 Express.