[Answer]-DatabaseError: ambiguous column name on annotation filtering

I had to specify the table name:

 truncate_date = connection.ops.date_trunc_sql('month', 'table_name.date_created')