Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to show only current year and current month when user click the button
Lets assume, i have data like below
Date Sales
01/01/2016 10
01/05/2016 20
01/01/2015 20
01/01/2014 30
01/01/2013 40
01/01/2012 50
01/01/2011 60
01/01/2010 70
Here, I want to create when user click the Button then i want to show data which related to
Max(Year) - Current Year
Current Max Month
How to add this actions into button?
Please help me
Sample attached
At Back End only, create a field as
num(monthname(Date)) as MOnthname_Num
Now in properties of a buttoon define an action as
Select in Field >>
Field>> Monthname_Num
VAlue>> max(Monthname_Num)
This way the data in chart will always reflect for selected or the max year month....
reards
Nitin
Can you please send the qvw
I would use a date field to do this
='>=' & Date(MonthStart(Max({1}Date)), 'MM/DD/YYYY') & '<=' & Date(MonthEnd(Max({1}Date)), 'MM/DD/YYYY')
Assuming your date format is MM/DD/YYYY and not DD/MM/YYYY
Sample attached
Thanks Sunny