BETWEEN and <= not selecting end points (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== BETWEEN and <= not selecting end points (AREV Specific) ====
=== At 28 OCT 2002 09:18:16AM Joe Nirta wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I'm having an issue on AREV 3.1 single user.

The command LIST  WITH ORDERED.DATE BETWEEN "01 AUG 02" AND "31 AUG 02" does not list anything on the end point dates,  it only lists dates from "02 AUG 02" thru "30 AUG 02".  I've tried replacing the BETWEEN with ]= and  WITH ORDERED.DATE=01 AUG 02",  it does return rows!



Thanks

joe
</QUOTE>
----

=== At 28 OCT 2002 10:16AM Dave Harmacek wrote:  ===

<QUOTE>Use FROM TO instead of BETWEEN.  Literally...

</QUOTE>

----

=== At 28 OCT 2002 11:06AM Joe Nirta wrote:  ===

<QUOTE>Still having the same problem...thanks

</QUOTE>

----

=== At 28 OCT 2002 12:21PM Victor Engel wrote:  ===

<QUOTE>What kind of conversion/justification do you have on the date field and the key field of the file? What do your keys look like? What happens when you try



LIST  WITH ORDERED.DATE GE "01 AUG 02" AND WITH ORDERED.DATE LE "31 AUG 02" 



Have you verified that the data stored for these dates is in internal format and not external format?



What if you type:



LIST  WITH ORDERED.DATE FROM 12632 TO 12662

</QUOTE>

----

=== At 28 OCT 2002 01:04PM Joe Nirta wrote:  ===

<QUOTE>Data conversion is (D) and I've checked the internal data. It is indeed in internal date format...12655 etc.

I've tried GE, ]=, =]..all yield same results.  I've tried building a SELECT list, then running LIST.

</QUOTE>

----

=== At 28 OCT 2002 02:18PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>What version of AREV 3.x?  There were some errors in 3.x that were fixed in 3.12 .. I think in ICONV / OCONV on dates, if I remember correctly.  Also, are your date fields RIGHT justified???



Don Miller

C3 Inc.

</QUOTE>

----

=== At 28 OCT 2002 04:01PM Victor Engel wrote:  ===

<QUOTE>(D) would be the input conversion. The relevant conversion here is actually the output conversion.

</QUOTE>

----

=== At 28 OCT 2002 07:36PM Richard Hunt wrote:  ===

<QUOTE>Joe,



I have just tested a select statement...



SELECT SA WITH DATE BETWEEN "1-4-0" AND "1-11-0"



That statement picked up all items perfectly, with dates of 1-4-0 thru 1-11-0, and all dates between also (inclusive).



My dictionary item for "DATE" has "output format" of "D2/" and "validation pattern" of "(D)".



I know this does not really help you, and I thought you might want to know that it works for me.



Oh by the way... I do not have "DATE" indexed.

</QUOTE>

----

=== At 29 OCT 2002 09:23AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Have you tried narrowing the selection down, moving the end points until you find one that works?





Also, BETWEEN is exclusive, and FROM...TO is inclusive.





[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World Leaders in all Things RevSoft[/i] 

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 29 OCT 2002 09:48AM Joe Nirta wrote:  ===

<QUOTE>Thanks for everyone's help.  I have the system installed on another machine and it works there!  I re-installed AREV 3.1 over the existing non-working sytem and it now works as well. ???



thanks

joe

</QUOTE>

----

=== At 30 OCT 2002 11:47AM Matt Sorrell wrote:  ===

<QUOTE>Quoth Sprezz:



[i]Also, BETWEEN is exclusive, and FROM...TO is inclusive[/i]



I use BETWEEN quite a bit in some of my routines, and it has always been inclusive . . .



Am I just lucky or am I missing something?



msorrel@greyhound.com

[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]

</QUOTE>

----

=== At 31 OCT 2002 08:48AM Don Miller - C3 Inc. wrote:  ===

<QUOTE>M@:

I think you're right (at least for AREV from 2.1x onward).  I think REV-G and early versions of AREV were EXCLUSIVE for the BETWEEN construct.  Anyway a test today indicates that BETWEEN is INCLUSIVE in AREV 3.12.



Don M.

</QUOTE>

----

=== At 31 OCT 2002 10:08AM Aaron Kaplan wrote:  ===

<QUOTE>I was having a moment...I was probably thinking of the BTREE.EXTRACT and the between/range difference.



That's my story, and I'm sticking to it.  So there. hrump.

</QUOTE>

----

=== At 31 OCT 2002 11:26AM Matt Sorrell wrote:  ===

<QUOTE>Quoth Aaron:



[i]I was having a moment...[/i]



Are you better now?  Do you need a tissue or a glass of water?



msorrel@greyhound.com

[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]

</QUOTE>

----

=== At 31 OCT 2002 12:39PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Or a laxative ..

Sometimes suffers from premature exclamation.





Don M.

</QUOTE>


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