@Mike

Ow sorry I made a typo. They are all DateTime values, there is no Date value in the expression.

[DateTime1] = â€ś3/21/2019 8:00:00â€ť

[DateTime1] = â€ś3/21/2019 7:59:00â€ť

[DateTime1] = â€ś3/21/2019 7:58:00â€ť

I was comparing if the earliest of the 3 DateTime values equate to the first DateTime value. Using the MIN() function, I tried to get the earliest DateTime value and then tried to compare to the first DateTime value.

The first expression was checking using the direct method of:

â€śIs earliest DateTime equal to the first DateTime value?â€ť

- This always returns TRUE, with whatever values I put in the 3 columns.

So I tried to reconstruct by wrapping the expression with NOT() and replaced the equal sign with not equal (<>).

â€śOpposite of the value given by (Is earliest DateTime not equal to the first DateTime value?)â€ť

- This now give me the logical value.

I hope I explained clearly