doc/modules/cassandra/examples/CQL/current_date.cql

SELECT * FROM myTable WHERE date >= current_date() - 2d;