How to schedule report for the article expiring within 30 days??

[swapsnil]

I want to schedule report which should run daily and creates list of those articles which are going to expire within 30 days.

[TJW2]

The Report is actually where you are going to filter the Articles that will expire in the next 30 days.

Create a Report with a Filter of:

You can then schedule your report to run daily, weekly, monthly.     The report will show all Articles where Valid to is in the next 30 days.

[juan_villalta]

Terry:

Your solution will show articles with expiring date less than 30 days from now, including all older than today. The requirement was for expiring in the next 30 days only. So this doesn't work.

[juan_villalta]

That can be accomplished by using 2 lines:the first one filters data starting the from-now-30-days and older (including older than today) and the second line restrict anything older than today. Yeah, silly but it works.

An elegant way could be to define the "Next 30 days', "Next 60 days" and the like. If SNC has the "last" ranges, why not having the "next" ranges?