SQL med Cdate problemer
'VariabelGammelTid=cDate(DateAdd("m",-4,now))
strSQL = "Select * FROM Plugs Where (Alive='Yes') AND (cDate(SetAliveDate)>"&GammelTid&") "
Når jeg kører den får jeg fejlen:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SetAliveDate)>2004-12-15 10:09:28) Order By PostDate DESC LIMIT 0, 20' at line 1
