Kbase P161077: MS SQL Server DataServer: Query with a date comparison does not return expected records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/03/2010 |
|
Status: Unverified
SYMPTOM(s):
Records created TODAY are not retrieved if the query contains a "<=" date comparison:
FOR EACH invoice WHERE invoicedate <= TODAY BY invoicedate DESCENDING:
DISPLAY invoice.
END.
FACT(s) (Environment):
Date field's initial value (invoicedate) is set to TODAY
OpenEdge 10.1x
OpenEdge 10.2x
MS SQL DataServer
MS SQL Server
CAUSE:
Bug# OE00176668
FIX:
Upgrade to 10.1C03, 10.2A01 or 10.2B