[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Date selection slow (AREV Specific) ====
=== At 07 MAY 2006 10:41:15PM mjmoran wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I have an rlist report which uses a date range criteria.

eg WITH DATE BETWEEN "1/1/06" AND "1/1/06"



The user can enter any date range, or a single day as above. The date field is btree indexed.



For some reason, the with+between is very slow. It almost looks as though indexing is not used at all. If I use "WITH DATE = I see the "using indexes" popup and the results are instantaneuous. But if I use "WITH DATE BETWEEN" (or ]= <=), even if the same date is used in the between-and, it seems to take so much longer (and I dont seem to see the "using indexes" popup).



Any ideas ?



Thanks,

Michael
</QUOTE>
----

=== At 08 MAY 2006 11:22AM Victor Engel wrote:  ===

<QUOTE>What else is in the select or list statement? What version of Arev are you using?

</QUOTE>

----

=== At 08 MAY 2006 02:13PM Ralph Johler wrote:  ===

<QUOTE>We too sometimes see this same problem.   Instead of this:



 WITH DATE BETWEEN "1/1/06" AND "1/1/06"



try this



 WITH CASEINSENS DATE BETWEEN "1/1/06" AND "1/1/06"



Apparently the "Advanced" in Arev refers to the ability to have Case Sensitive dates?

</QUOTE>

----

=== At 09 MAY 2006 06:29PM mjmoran wrote:  ===

<QUOTE>Hi Victor,



Arev 2.12, and that is the only thing in the record selection criteria.

</QUOTE>

----

=== At 09 MAY 2006 06:30PM mjmoran wrote:  ===

<QUOTE>Thanks Ralph,



lol @ the case insensitive dates



I'll give it a try.



</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=F02B7559D9513BCF85257168000EC377|View this thread on the  forum...]]