What am I trying Achive?
I am trying to create Month-To-Date Payment report which should only show the Data where payment was made in the current month
What I have done so far to achieve this?
What is the problem ?
The Reporting Task is also finishing with success but the excel report still contains data for all the months.
According to the log.. it is also recognising the variable filter Date(Today(),'MMM-YYYY') as Apr-2016
Thanks you for your time
try with separate filters
Year as max(year) and month as month(today())
Note: check month can be numeric/text --> (to check on IsNumeric)
This discussion (and the sample project) should give you some ideas previous month data
HTH - Daniel.