Skip to Content
author's profile photo Former Member
Former Member

GRAC_DELETE_REPORT_SPOOL and Report Date Selection

Hello everyone:

I want to schedule to run GRAC_DELETE_REPORT_SPOOL on weekly basis on each Sunday. For report date selection we would like to delete previous week's data.

I created a variant for this program. Attempted to use the condition [Current Date - 7] in field Report Date but it doesn't work. With this selection the program assigns [Current Date - 7] in "FROM" but leaves blank in "TO"; therefore, program doesn't delete previous week's data as expected.

We see that GRC provides the [Previous Month] selection. Just wonder if GRC has [Previous Week] selection ... as this is what I need. Thank you


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 21, 2016 at 02:07 AM

    Yes Andy,

    Creating a variant with this approach (Current +/- days) shows only From date and does not include TO date.

    This is more of a Variant usage issue (not GRC).

    I really doubt, if this can be achieved weekly automatically. Definitely, program can run manually with any date selection, but this will not solve your purpose and increase admin efforts.

    May be you can use monthly approach like every first day of month or specific date of every month.

    Thanks & Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2016 at 07:33 AM

    Hi Andy,

    I investigated further and found that you can use "Current date - xxx, Current date + yyy" selection variable instead of "Current date +/- ??? days" variable.

    This will help to get your selection criteria.

    Thanks & Regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.