
If I want to check if the "Due Date" object on the left has already occurred (to see if an object is overdue), would I use < or >? I am not sure whether a date being in the past would make it greater or less than today's date - I am assuming that I should use <.
First, SharePoint stores everything as UTC time and in the format yyyy-MM-dd
The two dates must be in the same format for you to cmpare.
I mention this because it looks like you have used a convert time zone action.
A better way to approach this might be as follows: