Is there a way to filter on the current month with the equal function in the filter list operation?
Hello, Im trying to calculate the sum of a value, but before I do that I want it to only use the values of the current month. I tried using the [%BeginOfCurrentMonth%] but that only takes the first day of the current month. Is there a way to use the entire month within the equal.
Dennis Maassen van den Brink
I'm assuming you have a list of objects. and that object contains a date atribute.
1: You can put 2 filter actions before the sum action.
(1 filter is after begin of current month, 1 filter is before begin of next month)
2: if you retrive the list from the database it would even be better to filter with xpaths.