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___
