Try DATE() instead of $DATE$()
HTH
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy
Application
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
From: Action Request
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mathieu Pitre
Sent: Tuesday, September 19, 2006
3:52 PM
To: [email protected]
Subject: Re: compare date only
from Date&Time fields.
James,
It
does not work, I am receiving an error msg when I try to save my action:
Here
is my qualification:
(
$Server Name$ = 'Server Name') AND ( 'Entry-Id' != $LASTID$) AND
($DATE$('Date/Time of Change') = $DATE$($Change Performed date$))
Here
is the error msg:
Expected
a relational operation at this point (ARERR 2293)
Qualification
line error at position 73
Am
I missing anything here?
Mathieu Pitre
IT Business Systems Analyst
Production Operation
Computer
Sciences Corporation
Pratt & Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office: 450-647-8008 x7030
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please delete
without copying and kindly advise us by e-mail of the mistake in delivery.
NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any
order or other contract unless pursuant to explicit written agreement or
government initiative expressly permitting the use of e-mail for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
"McKenzie, James J C-E
LCMC HQISEC/L3" <[EMAIL PROTECTED]>
Sent
by: "Action Request System discussion list(ARSList)"
<[email protected]>
19/09/2006 10:26 AM
|
|
**
Frank:
You hit the nail on the head so's to speak:
$DATE$($plannedDate$) = $DATE$('plannedDate') AND ( $Server Name$ = 'Server
Name')
should work in this case. However, it would be a good idea if the
plannedDate field were actually a date and not a date/time field,
James McKenzie
________________________________
From:
Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso
Sent: Tuesday, September 19, 2006 6:16 AM
To: [email protected]
Subject: Re: compare date only from Date&Time fields.
** How
about doing a set fields against the two date fields and use the DATE function
to convert the date time to just a date. You could store the results of each in
either a display only character or date field and then do your comparison.
On
9/19/06, Mathieu Pitre <[EMAIL PROTECTED]> wrote:
Hi
all,
I would
like to compare two time and date fields by considering only the
dates
(First 8 characters). I am developing an application and I need to
see when
there is a conflic in my change request schema. Basicly, I am
creating
a Change-Request from an application and I would like to go over
all
those that are already created(and not closed obviously) to see if any
of them
is planned to be performed during the same day and on the same
server.
I am
looking for something like this (Set field Qualification):
leftc
($plannedDate$, 8) =leftc('plannedDate', 8) and $ServerName$
=
'ServerName'AND ( 'Entry-Id' != $LASTID$)
The
qualification above does not work because I can only use the LEFTC
function
in the result value and not the qualification. Therefore, I have
created
another set field just to use the LEFTC for the $plannedDate$ in
order to
have just the date. Then I tried the following:
(
$Server Name$ = 'Server Name') AND ( 'Entry-Id' != $LASTID$) AND
(
'Date/Time of Change' LIKE (( "%" + $plannedDate(DateOnly)$) +
"%" ))
This
qualification does not work either because I cannot use the LIKE
function
on a Date and Time field. I do not want to separate the field into
two
field (Date in one field and time in another one).
A
suggestion would be appreciated.
_______________________________________________________________________________
UNSUBSCRIBE
or access ARSlist Archives at http://www.wwrug.org
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with
HTML in it___
__20060125_______________________This
posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
