How to filter a report on a date being in the range of a different date prompt

[tinas]

Hi all.  I am struggling with how to filter a page of a report based on a date data element - 'Begin Effective Date' being in the range of a date prompt.  The date prompt is for a range based on a different date data element  Trigger Date

How do I only includes records on the report where the Begin Effective date is in_range of the Trigger Date prompt?  I've tried using the in_range function and it does not work.

Any suggestions would be appreciated!

[MFGF]

Hi,

How have you coded your filter?

[Begin Effective Date] in_range [Trigger Date] (which would not work) or
[Begin Effective Date] in_range ?Trigger Date Parameter? (which should work, provided the prompt is defined appropriately)

If this is not the problem, can you give us more details - the datatype of [Begin Effective Date], how your prompt is coded, and the syntax of your filter, for example.

Regards,

MF.