extract dates dynamically

[nagasekhar]

dia:

order,id,name,status,date

product:

id,description

I want last two months dates dynamically from today

[brunobertels]

hi may be this 

dia:

order,id,name,status,date

product:

id,description

from ... 

where date>=addmonths(date,-2);

I want last two months dates dynamically from today