How do I create a calendar (x2) for minimum and maximum date range based on a single value?

[#1]

Hello, I am writing a report where I want to restrict data by date range in the form of a calendar x 2, one for minimum range and one for maximum range.

Thanks.

Paul.

[Anonymous]

Hi Khaled,

Very helpfull and thourough application.

I think it was important to point out the action that is needed once you select both Start and End Date

='>=' & Date(vStartDate, 'M/D/YYYY') & '<=' & Date(vEndDate, 'M/D/YYYY')

Gysbert had omitted to mention the triggers used in his app It took a minute to understand how the selection was being made.

Cheers,

Benoit

[Anonymous]

Hi Benoit,

I was scratching my head on that one.  Knew there had to be something to tell it greater/less.

Now, my question is, where is that added?

Thanks

[Anonymous]

Hi Darrin,

In Gysbert's example SalesToDate12, you have to add the triggers to the variables.

Settings > Document Properties > Triggers/Variables Event Triggers.

You should have listed the 2 variables you created for the 2 input calendars - in his case vMaxDate and vMinDate.

Add the actions OnInput. Select In Field on your Date field.

='>='&Date(vMinDate)&'<='&Date(vMaxDate)

That is essentialy what Khaled is doing in his example; he just uses an button/action to do so.

Cheers,