Current and previous months

[Anonymous]

Hi!

Trying to add action to select current and previous months in max year as a default, Month(Max([Date])) returns only the current month

Thanks

Kwame

[#2]

Kwame,

Fot the field WEEK I defined an action as ='<=$(=week(today()))'

This sets all the weeks.

For te field YEAR I defined an action as =year(today())

The combination of these two actions sets the YEAR and the WEEKS.

Regards,

Gerrit

[Anonymous]

try you

Month(addmonth(Max(date),-1))

[Anonymous]

Hi! Guys

The expressions are not giving the desired results.

=vMaxYear returns the current month ie. 2013 and now i would want all the months selected suppose the current month is July. So essentially when i open the document the 2013 and months Jan,Feb,Mar,April,May,June and July should all be selected

Thanks