Date Parameter Start not more than 6 months

[porsche2k7]

Hi All,

I am trying to figure out a way to create a date parameter where the value which the user selects cannot be more than last 6 months. OR
Is there any way I can restrict the user to select the date value to previous 6 months for the date parameter.

Can we accomplish this without using Business Views?

Thank you.

 

[IanWaterman]

Add this to select statement, wrapped in () so can be used with other clauses.

(If {?dateparam} < dateadd("m", -6, date(year(currentdate), month(currentdate), 1))
then {datefield} >=  dateadd("m", -6, date(year(currentdate), month(currentdate), 1))
else
{datefield} >= {?dateparam})

Ian

 

[porsche2k7]

Thanks Ian. My report is based on SQL command which is something like below.

Select product, network, sum(duration) from event_table where event_date between {?BeginDate} and {?EndDate} group by product, network

Since parameters BeginDate & EndDate are Dates, the calendar shows up to select the dates. I need to restrict the calendar to not show dates more than last 6 months. I can set a start value in the date prompts properties which will restrict the user to enter a date after the start value. However, that would not be dynamic.

I can't use the formula you suggested in the report select expert since I do not have the event_date in the select statement due to grouping. Please let me know if you need more info. Thank you.

 

[IanWaterman]

Sorry misunderstood your question. I do not know of any way to restrict Calendar.

Ian