Dynamic Date Range Prompts

[JaC74]

Any insight on this issue will be appreciated. I am trying to create a report where the metrics will be calculated based on date range(two prompts). Here is the tricky part. The prompts have to be attribute element list prompts. The second prompt must be populated using the first prompt answer and logic. Here is the exact example I am trying to accomplish.

User runs the report. First prompt lists all dates and allows the user to only select 1 date. The second prompt must be populated based on the 1st prompt answer plus all dates 90 days forward.

I am trying to create a filter where DateID Between (ApplySimple("(#0)",? [Select Date]) AND ApplySimple("(#0 + 90)",? [?Select Date]). With this filter, I can limit the elements brought back by the second attribute element prompt. The problem is that it is only allowing Value Prompts to be validated in the ApplySimple statement. All other types of prompts are not allowed.

Any way around this?

 

[entaroadun]

Try using ApplyComparison instead. Also, attribute element prompts, when used in pass-thru, already have the attribute form column embedded within it.