You are viewing limited content. For full access, please sign in.

Question

Question

Forms Custom Report Date Range Filter

asked on September 18, 2020

I am creating a custom report and would like to filter the results based on my form process started within the last week and set it on a schedule to run every week.  Is this possible?  I don't see a way to filter based on a variable but maybe I am missing it.  We are on Forms version 10.4.2.381.

Thanks

1 0

Replies

replied on September 22, 2020

You can click the "Filters" button at the bottom of the edit report page and add filter based on system variable such as "Start date" or process variables.

0 0
replied on September 23, 2020

Yes I do understand you can do a filter but can you do a variable in your filter for the start date so it looks at any created within the last week and not a specific date.  So I can set it to a schedule and each week when it runs it looks at the current week.

0 0
replied on September 23, 2020

I understand now, currently variable is not supported in the value for filter, you can't set to something like "start date is after @Today("-7d")"

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.