Jacob Wilkins (9/16/2016)

---

Seems like you have time components in the columns you're comparing.

You're wanting it to just compare the date portion, but it's going to compare the full values...

The date show like this:

08/31/2016 10:30:50 AM

Now where I am not seeing my desired result is in this result

Order Received Date ...

Got it and I see that now.

Ok, so last bump is:

Two dates are the same (=) then it should be "NEW", then the dates do not equal (=)...

Thank you! I was looking at that and did not thing of the "bit" as a numeric value. So if I want you use NEW and OLD then...

gotcha, for me I have no problem with the 24 clock, I understand it, my boss however, well, she wants to see the AM/PM, lol. I will just throw...

so don't use the smalldatetime?

or change the format to the 24 hr?