[SQL] Zeiträume abfragen

[quendolineDD]

Es handelt sich um MySQL.
select count(gid) from gespraech where kid=1 and Datum between now and (Now - 1 year) #1064 - 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 'year)' at line 1
Kennt das -1 Year / Jahr nicht.

Bzw wenn ich select count(gid) from gespraech where kid=1 and Datum between Now() and (Now - 1) mache kommt #1054 - Unknown column 'Now' in 'where clause'

Edit:

Habe die Abfrage etwas spezialisiert:
select count(gid) from gespraech where gid=1 having Datum>(Now - 1) Nun kommt #1054 - Unknown column 'Datum' in 'having clause'