Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
try you
Month(addmonth(Max(date),-1))
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