Skip to Content
0
Former Member
Dec 09, 2009 at 05:39 AM

Display dates prior to next 60 days

99 Views

Hi

I need to query a report where in I have to display all the expiry dates for the Next 60 days and this report is scheduled on 1st of very month. This is how I have used and is working fine.

{AST_Asset.Contract End Date} in minimum(Next30Days) to maximum(Next31To60Days);

Along with this, I also want all the expiry dates prior to the date of generation of the report.

So the best way to expalin this is as follows:

Contract End date >= the next 60 days or Contract End date <= Current date

Can someone hlep?

Regards

Cauvery