Inline Formula question (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

Inline Formula question (AREV Specific)

At 02 MAY 2001 05:46:35PM Matt Sorrell wrote:

AREV Specific

I'm having some problems getting an inline formula to work in a TCL SELECT statement.

Running ARev 3.02.

The command is:

SELECT 10 EMP WITH ACTIVE_STATUS_DATE GT {DATE() - 120}

I get 10 employees back, but when I look at the date field, it is all over the place, and does not meet the criteria I provided.

I ran the select again, and then did a list statement, including the inline formula above as a column to be listed:

LIST EMP ACTIVE_STATUS_DATE {DATE() - 120}

The second column is always listed as the current day's date. It appears to be using the Date() function, but then not subtracting 120 from it.

Now, if I create a symbolic with @Ans=Date() - 120, and then select against that, everything works fine.

Is this a bug, or do I have a syntax error?

msorrel@greyhound.com

At 02 MAY 2001 06:37PM Warren wrote:

Not tested but:

Try adding parentheses

Either {(DATE() - 120)}

or (ACTUALDATE GT {DATE() - 120})

???

At 03 MAY 2001 08:16AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

FWIW I always use an explicit @Ans assignment so

{@Ans=(Date() - 120)

and I might be tempted to ensure the comparison field had no iconv/oconv defined.

The Sprezzatura Group

World Leaders in all things RevSoft

View this thread on the forum...