I am trying to run the Recently Modified Diagrams and Recently Modified Elements reports agains my Access 2007 database and I am getting a Syntax error in the Where clause. Perhaps the DB command for Access 2007 is not included in the SQL below. Can anyone help me out - what should the line of code be for Access 2007?
SELECT ea_guid AS CLASSGUID, Name, Version, Author, StereoType, CreatedDate, ModifiedDate
FROM t_diagram
WHERE
#DB=MYSQL# t_diagram.ModifiedDate >= DATE_SUB( CURDATE(), INTERVAL <Search Term> DAY) #DB=MYSQL#
#DB=JET# DateDiff("d",t_diagram.ModifiedDate,Now()) <= <Search Term> #DB=JET#
#DB=ORACLE# t_diagram.ModifiedDate >= (SYSDATE - INTERVAL '<Search Term>' DAY) #DB=ORACLE#
#DB=SQLSVR#DATEDIFF(day, t_diagram.ModifiedDate, getdate()) <= <Search Term>#DB=SQLSVR#
#DB=ASA#DATEDIFF(day, t_diagram.ModifiedDate, getdate()) <= <Search Term>#DB=ASA#
#DB=OPENEDGE#(SYSDATE - ModifiedDate) <= <Search Term>#DB=OPENEDGE#
#DB=POSTGRES#ModifiedDate >= (now() - interval '<Search Term> day')#DB=POSTGRES#
Thanks,
Carol
