I don't think you can subtract from the timestamp like that can you? Have
you tried using a datediff to get the proper date?
On Fri, 27 Oct 2006 15:55:35 -0400, Leigh Gruber [EMAIL PROTECTED] wrote:
Hi Everyone,
I met a number of you at the 2005 RUG and am sorry that I didn't get to
this
(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Friday, October 27, 2006
5:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Direct SQL - How can
I use a $TIMESTAMP$ reference?
Hello Leigh,
Try setting the $TIMESTAMP$ value to hidden, display-only integer field, then use
Leigh,
Try the following statement (I've substituted a SQL-based calculation of
epoch time for the $TIMESTAMP$ value):
SELECT count(*) FROM Issue
WHERE Customer_Abbreviation = '$Customer_Abbreviation$' AND
Create_Date (ABS(DATEDIFF(ss,GetUTCDate(),'1970-01-01')) - ($Threshold
Days$ * 24 *
**
Hi Everyone,
I met a number of you at the 2005 RUG and am sorry that I
didnt get to this years gathering. My husband and friends
DID have successful English Channel relay swim over and back so I missed the
event for a good reason. Hope to see you next year!
Now my question. I am
:
gmane.comp.crm.arsystem.general
Sent: Friday, October 27, 2006
14:55
Subject: Direct SQL - How can I use a
$TIMESTAMP$ reference?
**
Hi
Everyone,
I met a number of you at the 2005
RUG and am sorry that I didnt get to this years gathering. My husband
and friends DID
**
There is a SQL Server function called datdiff which lets you get the difference be two dates and return seconds. So something like:select datediff(s,'12/31/1969 8:00:00 PM',getDate()) would get your time in seconds.
On 10/27/06, Leigh Gruber
[EMAIL PROTECTED] wrote:**
Hi Everyone,
6 matches
Mail list logo