We did Select case with completed.date from ?06/07/99? to ?06/08/99? and it returns 339 rows. We then used just changed the word select to list and received 0 rows processed.

List case with completed.date from ?06/07/99? to ?06/08/99?

Are the variables embedded in quotes (e.g. between ?"START DT"? and ?"End DT"?)?

Yes. I actually wrote the statement to you wrong. We used ' (single quotes) and not ? (question marks).

Select case with completed.date from ?06/07/99? to ?06/08/99?

(returns 339 rows)

and then…

List case with completed.date from ?06/07/99? to ?06/08/99?

(returns zero records processed.)

Thanks so much for your help. :)

What is the justification on the field? Have you verified that all the actual values (internal) are numeric?

Which version of ARev? During the so-called Lightspeed project the select/list processor was broken, I believe that was in some of the 3.0x versions.

Do you indexing on the field in question? Make sure it is right justified and rebuild if necessary.

In the list, try adding the kewords CASEINSENS or CASESENS just before the fieldname. You also might want to try changing the from..to to a greater than, less than type.

[email protected]

Sprezzatura Group

It is Arev 2.12. The completed date IS an indexed field. It is left justified. We will change it to right justified and rebuild the completed date index. Thank you. :)

It was left justified. We will change it and then rebuild the index. I will find out if the actual internal values are numeric. Thank you. :)

For what it's worth Revelation and probably early versions of Advanced Revelation (<1.13??) the SELECT/LIST processor would behave oddly (at least compared to other Pick systems)

Example:

SELECT INVOICES WITH INVOICE.DATE BETWEEN "01/01/88" AND "12/31/88"

(returns let's say 2000 hits)

followed by:

LIST INVOICE WITH INVOICE.DATE BETWEEN "06/01/88" AND "06/30/88"

(would list all 2000 records even though the correct number should be far lower).

It could have been that this only happened on a SAVE-LIST/GET-LIST sequence, I don't recall but I pointed this out to my Revelation distributor at the time and he reported it to Cosmos. And using WITH INVOICE.DATE GE xxx and WITH INVOICE.DATE LE xxx made no difference.

BTW: There is a 2.12 patch download available in the Demos and Download section. I don't recall what exactly it changes/fixes but you might try that too.

Thank you so much. The left justified date was the problem. It looks good now. :)

Thanks. The left justified date was the problem. It looks good now. :)

Thank you so much. The problem was that it was a left-justified date. It looks good now. :)

View this thread on the forum...