I was able to query the Denodo view by using the **ADDMONTH()** Datetime Processing Function. I used a similar condition and able to receive results successfully.
select * from <database_name>.<view_name>
where <field_name> >= addmonth(current_date,-6)
For more details, you can refer to the [ADDMONTH](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#addmonth) section of the Virtual DataPort VQL Guide.
Hope this helps!