how to pull data that is older than 6 months on Crystal Report XI?

Question

I have a field titled COMPLTDATE that is a DATETIME; however when I write,within select expert, {ORDERSEC.COMPLTDATE} >= currentdate - 6 months I receive an error.

How should I write it so that it pulls all the data from the last six months ?

Answer 1

{ORDERSEC.COMPLTDATE} >= DateAdd ('m',-6 ,currentdate)