dharkangel
MIS
Hello everyone, I discovered a tricky problem in my query. I checked the data against my results and something weird is happening. I copied my WHERE statement below because this is where the problem is happening. The part where I have tableName.[Close Date] <= tableName.[Original Commit Date] is the problem. In my database I have an entry where the Close Date and Original Date are equal to each other. This query below is not picking it up. But when I changed the operator to be greater than (tableName.[Close Date] > tableName.[Original Commit Date]), it displayed the entry??? Should I not be comparing dates like this??
WHERE BarcelonaInternalActions.Status="Closed" And BarcelonaInternalActions.[Close Date]<=BarcelonaInternalOGCommitDate.[Original Commit Date] And (BarcelonaInternalActions.[Close Date]>=DateValue("2/27/2006") And BarcelonaInternalActions.[Close Date]<DateValue("3/6/2006"))
WHERE BarcelonaInternalActions.Status="Closed" And BarcelonaInternalActions.[Close Date]<=BarcelonaInternalOGCommitDate.[Original Commit Date] And (BarcelonaInternalActions.[Close Date]>=DateValue("2/27/2006") And BarcelonaInternalActions.[Close Date]<DateValue("3/6/2006"))