Ive tried two methods to try and get this to work and while both methods "work" with no errors, they both produce the same incorrect data set.
I have a STATUS column which designates which stage a project is in, a Development End Date Column and Testing End Date Column.
I'm trying to send an email late notice reminder where:
If Status is Development and Development end date is past due
Or
If Status is Testing and Testing end date is past due
(Etc etc with other late statuses eventually) all put into a HTML table and emailed out
Both methods find and filter the Develop status and overdue dates just fine and returns the correct result.
However when it comes to the Testing, both flows return ALL Testing statuses and there's no overdue date filtering happening for those items. What am I doing wrong?