Hi Rabi,
Have you tried performing the calculation on the left side of the
qualification, such as:
( $Date Field On Current Form$ + 1 ) < 'Date Field on Source
Form'
Not positive that will help, but I've seen other qualifications in the
past, where it worked fine with the arithmetic performed on the left,
but not the right.
Also, are you positive the date field on the current form has a value at
the time the table qualification is read? In other words, it is not
evaluating as:
'Date Field on Source Form' > ( $NULL$ + 1 )
Eric Cleereman
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Rabi Tripathi
Sent: Friday, November 02, 2007 5:29 PM
To: [email protected]
Subject: Arithmetic on date field values...doesn't work in table
qualification
I can do arithmetic on a value on a date field fine to do stuff like add
1 to a date in set field action to get the next day.
However, in a table's qualification, a clause such as:
'Date Field on Source Form' > ( $Date Field On Current Form$ + 1 )
or any other kind of addition to a date field on source or current
form's date field causes:
ARERR [313] Data types are not appropriate for relational operation
on refreshing the table.
Since arithmetic works in set field actions, there is not logical reason
it shouldn't work in a table field qual, so I want to mark this as a
bug.
Anyone seen this? I don't think date/time fields have this issue.
I am trying to avoid having to do the arithmetic on a separate field and
reference that field in the qual.
ARS 7.0.1 p3 on Win 2003. Remedy User 7.0.1 p4.
TIA.
__20060125_______________________This posting was submitted with HTML in
it___
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com __20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
