'In between' Dates Pipelines

Has anyone attempted to use the 'in between dates' condition in Pipelines?

I tried to set the condition in between two date fields, and it simply didn't yield any results (though it should have).

So then as a test I hard coded and said if the date is between "09-25-2020 and 09-27-2020". I expected to get one date, instead it returned a completely seemingly arbitrary result. Here's a small snip of what it returned.

Anyone know what is going on??

		08-24-2020
		08-26-2020
		08-27-2020
		08-31-2020
		09-03-2020
		09-08-2020
		09-16-2020
		09-19-2020
		09-21-2020
		09-24-2020
		09-27-2020
		10-02-2020
		10-03-2020
		10-04-2020
		10-05-2020

------------------------------
Mike Tamoush
------------------------------