R/LIST and multivalues (AREV Specific) [Revelation On-Line Wiki]

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

At 23 DEC 2001 08:48:13AM Bob Silverstein wrote:

AREV Specific

I have four multivalued date fields, DATE1, DATE2, DATE3 and DATE4 and I would like to display only today's value for each date and an associated value. I tried the LIMIT function in R/LIST (LIST ORDERS LIMIT DATE1=TODAY OR LIMIT DATE2=TODAY OR LIMIT DATE3=TODAY OR LIMIT4=TODAY DATE1 VALUE1 DATE2 VALUE2 DATE3 VALUE3 DATE4 VALUE4). Problem is that for DATE2 to DATE4, all the multivalues appear. Any way of suppressing the dates (and their associated values)?

At 23 DEC 2001 01:01PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Bob, you're better off defining a symbolic that isolates and returns the date and its associated value.

The Sprezzatura Group

World Leaders in all things RevSoft

At 24 DEC 2001 01:55AM Bob Silverstein wrote:

That is what I was afraid of. I did indeed do that and got the desired results.

View this thread on the forum...