Display customers who have not ordered in 60 days

[magicrjm]

In our order table, a date field is populated each time a customer service rep enters an order. I'm trying to create a formula on my Crystal Report that will only display customers that have not ordered in the past 60 days. I'm using Crystal 11.

I was entering a formula on our order date field in the database. I thought I had it when I used {oeordhdr_sql.ord_dt} < CurrentDate - 60, BUT this formula is not verifying if there are order > than 60 days. It seems that I would need to have an if then statement. Am I right? Can someone help or point me in the right direction?

 

[lbass]

Insert a group on customer and then go to report->selection formula->GROUP and enter:

maximum({oeordhdr_sql.ord_dt},{table.customer}) < currentdate-60

-LB

 

[dev777]

This should work..

Not (currentDate>DateAdd('m',-2,{oeordhdr_sql.ord_dt}))

 

[magicrjm]

I used formula suggested by lbass. Thanks, looks to be working great!