Question

How to filter on the current month?

0

Hello, I want to be able to filter my data on only the current month. I want to do this because i want to calculate my total amount of hours worked for the current month. Ive tried doing this with a filter in my microflow but i can't seem to get it right. Below is how I currently have my microflow setup.

asked 2020-01-10

Dennis Maassen van den Brink

3 answers

Gerrit Kiefer · Answer 1 · 2020-01-10

Could you share your filter settings?

Gerrit Kiefer · Answer 2 · 2020-01-10

Have you investigated the filtered result in the debug mode or do you get a error in the modeller (if yes, which one)?

Gerrit Kiefer · Answer 3 · 2020-01-10

Thats right, you’re filter option says that you will only the first day of your month will be filtered. I assume your data is persistent data, isn’t it? Have you tried to use and filter by a xpath call? So that means you retrieve from the database a list based on your filter criterias by xpath and then you can use the aggregeation onthe result list.