Hello,
I may see the issue.
If the above formula you copied into this comment is the one you are using, I can see why everything is coming back on time.
The < you have pointed like seen should be pointed the other way like seen here >.
Try that first and let us know. As long as the columns are truly date columns, this should work.
Mike B
Automation Architect