I checked in the documentation and found that both $DATE$ and
$TIMESTAMP$ resolve to current date when used with a Date field (not to
be confused with a Date/Time field set to display as Date). It appears
that the arithmetic is not being performed in the comparisons.
'my_date_field' < ($DATE$ - 120) and 'my_date_field' < ("$DATE$" - 120)
is functioning the same as 'my_date_field' < $DATE$
Looking through documentation, I was not able to find examples of
Advanced Searches using a Date field with addition or subtraction.
I do know that setting a Date field with $DATE$ + X, one must use number
of days and not seconds to for the addition to work properly.
Has anyone asked Support if this is supposed work like
addition/subtraction with a Date/Time field?
Dave
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Milke
Sent: Tuesday, October 28, 2008 6:56 AM
To: [email protected]
Subject: Re: Adding days to a Date field in a qualification doesn't work
> An easy way to do this is to use the multipliers. You will also need
to
> use $TIMESTAMP$
>
> 'my_date_field' > ($TIMESTAMP$ + (60*60*24*182))
>
> $TIMESTAMP$ returns the number of seconds elapsed since midnight
> Coordinated Universal Time (UTC) of January 1, 1970.
>
> Guess what platform Remedy ARS was first built upon? That's right
UNIX.
> There used to be 3 clients. Anyone know what they were? Note: Remedy
ARS
> was built before there was a Public Internet. Come to think of it,
there
> may have been 4 clients at one time, but there may not have been one
for
> IBM OS/2.
>
> When you do it this way, you can substitute a $variable or a number
> whenever you like.
I've tried that too, of course. When your my_date_field is a DATE
field the example you're showing will n o t work.
At least on my 6.3 patch 024 it just doesn't work.
Thanks anyway!
Mark
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
