Friday, March 23, 2012

How controls a range of dates?

I have a report that asks for two dates and wanted to control that the
difference between two dates is not superior to two months.
Exists some way to control the dates before clicking the button of "View
Report"?
Thanks,On 28 Jun., 12:18, Cetel Sistemas
<CetelSiste...@.discussions.microsoft.com> wrote:
> I have a report that asks for two dates and wanted to control that the
> difference between two dates is not superior to two months.
> Exists some way to control the dates before clicking the button of "View
> Report"?
> Thanks,
Hi
If I understand you right, I think a solution would be to make the
second date dataset dependent of the first selected date parameter.
You could use the datedif() function. In that way you only display
dates for the second date that in is the allowed range.
-Henrik.

No comments:

Post a Comment