I have a simple SharePoint list.
ID | Title | Due
1 Dave 01/15/2020
and created a workflow to fire the first day of each month. I.e 01/01/2020, 02/01/2020 etc.
My goal is to go through my list, and email me a list of items with a due (date) occurring in the month. So if I run April 1, I should see items due for only April. If I run May, I should see items due only for May.
For the life of me I can't grasp how to write the filter array. I found this;
@lessOrEquals(formatDateTime(addDays(item()?['Due'],30), 'MM/dd/yyyy') utcNow('MM/dd/yyyy'))
but it returns all items from the beginning.
This returns everything from Jan through April.
