How to create report on due date of catalog task

[BijoyDeb]

Hi all,

I have to create one report and I am getting super confused

How can I show all catalog tasks whose due date is in next 30 days?

[Mark Manders · Accepted solution]

Create a report on sc_task where state is not completed (assuming you only want the open ones) and due_date is relative 30 days from now. 

I would also add 'or due date is empty', just in case, but that's up to you: 

[Robbie]

Hi @BijoyDeb,

Assuming my understanding of this is correct in that you only want to see Tasks with a due date 30 days from now, which does not include any that have a due date that has already passed, this can be achieved by leveraging the 'Due date' column and condition builder using the between option. (Between today and next month as shown below)

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie