Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am struggling to setup a bookmark which defaults the filter to the current month and year.
I've tried writing an expression within the filter as per this youtube video (https://www.youtube.com/watch?v=tFyqOigqnUw) but no matter what I do it just wont work - it simply creates a bookmark and hardcodes the current month selected in the bookmark expression.
My filter field is called start.autoCalendar.YearMonth and I've tried variations of the following expression =start.autoCalendar.YearMonth=MonthStart(Now())
Any help to understand what I am doing wrong would be much appreciated.
create a variable: =MonthStart(Now())
and use a variable filter
OR
just apply filter as
=MonthStart(Now())
not =start.autoCalendar.YearMonth=MonthStart(Now())