Simple math. Date / 86400. Drop the remainder. Multiple the results by 86400 and that will give you the date of any timestamp minus the time. Watch date jumps for timezone. You can drop the remainder by putting the results into an integer field if you don't know how to drop the remainder.
Just another way to attack the problem.
Brian Goralczyk
**Matthew:May I step in here as I have done this before. First, determine the field(s) you are going to do the comparision on. If there is only one field then you can convert that one field to a temporary field (I like the convention that BMC uses of adding a zTmp to the field name.) For example, you want to convert the field Ready Time to see what date is in the field. I would name the temporary field zTmpReadyDate and then use workflow to fill the field like this:Qualification: Set ormodify of Ready TimeSet fields: zTmpReadyDateValue: Date(ReadyTime).You can do this for multiple fields by adding to the Qualification or using multiple filters/escalations. I highly recommend using different sequence numbers.James McKenzie
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mathieu Pitre
Sent: Tuesday, September 19, 2006 8:26 AM
To: [email protected]
Subject: Re: compare date only from Date&Time fields.
Frank,
I understand that I need to convert my date&time fields into a single date field first but what mechanism shall I use to achieve this considering the fact that they there is multiple change requests? I need to do a set field for each changes created and do my comparison every time. How I am going to that?Mathieu Pitre
IT Business Systems Analyst
Production OperationComputer 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.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Frank Caruso <[EMAIL PROTECTED] >
Sent by: "Action Request System discussion list(ARSList)" < [email protected]>19/09/2006 10:55 AM
[email protected]
[email protected] Re: compare date only from Date&Time fields.
** You must first do a set fields action to convert your two date time fields to date only using the DATE function. The DATE function is not available in the qualification line. Teh DATE in the qualification line is todays DATE.
On 9/19/06, Mathieu Pitre <[EMAIL PROTECTED] > wrote:
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
[email protected]
[email protected] Re: compare date only from Date&Time fields.
**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___
--
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___
