I'm trying to Query a list based on a Date Range, Store them in Collection and then pass through a For Each and then into a HTML Email. I've done something similar in the past. But I'm having some issues and would I apperiate your help.
I have a list that I need to query with the following Filter Field "Date" is greater than or equal to 2/1/2020 (or a range of 2/1/2020 to 2/29/2020,I'm using this at the end of each month). I take those results and store them in a Collection Variable and then a For Each into a HTML Table. I'm having a number of issues. The main issue at the moment is the query of the list.
1. Can a query be based on a Date? I'm not able to get it to work even when I make the Date equal a specific date.
2. I tried adding an additonal calucated column to my list that says Yes the date is greater then Date and that didn't work either. Does anyone have any sugguestions on how I can accomplish this.
Nintex Workflows, SharePoint 2013