You could use the undocumented PWDENCRYPT() and PWDCOMPARE() functions in SQL. The PWDENCRYPT encrypts the password as it suggests and the compare take a string and compares it to the...

If you aren't interested in the time period in the where clause you can convert your A.Date1 to remove the time.  This should then remove the problem of times after...