Access 2007 SQL View Where Clause Help
Posted on 2014-04-02
I need to correct the below Where clause so (access 2007 sql view) it finds all records in table
dbo_dAgentPerformanceStat that have a date 1 day less than todays date (if todays is 04/02/2014).
Right now the below WHERE code is not finding match since the Timestamp is
2014-04-01 00:00:00 and DateSerial is calculating date as 04/01/2014.
dbo_dAgentPerformanceStat.Timestamp = 2014-04-01 00:00:00
DateSerial(Year(Now()),Month(Now()),Day(Now()))-"1")) = 04/01/2014
How would you create a Where clause that will compare the correct way so I find matches ?