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