Date/time is stored as an Epoch value - the number of seconds since 01/01/1970. Date without time, defaults to 00:00:00 on the day specified.
....> $Date$ - 60 * 60 * 24 would return records with values since
yesterday 00:00:00.
...> $Date$ - 60 * 60 * 24 and ...< $Date$ would return records with values
only for yesterday.
(86400 is OK instead of 60 * 60 * 24).
Mike White
Office: 813-978-2192
E-mail: [EMAIL PROTECTED]
Randy Simon
<[EMAIL PROTECTED]> To: [email protected]
Sent by: "Action cc:
Request System Subject: Find issues from days
past
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
08/28/2008 08:44
Please respond to
arslist
**
I am setting up an escalation to run a report on tickets created the
previous day, previous week, and previous month.
Is there anyway to do something like $Date$ - 1, or $Date$ - 7?
I want to capture the entire previous day, month, or week.
I know Crystal can do this, but I do not want to use Crystal at this time.
ARS 6.0
CSS 5.0
SQL 2005
Randy Simon
Remedy Admin
Online Resources Corporation
________________________________________________________________________
STATEMENT OF CONFIDENTIALITY:
The information contained in this message or any attachments to this message
are intended only for the person(s)
or entity to which it is addressed and may contain confidential and/or
privileged material as well as being
protected from disclosure.
Any review, retransmission, dissemination or other use of, or taking of any
action in reliance upon, this
information by persons or entities other than the intended recipient is
strictly prohibited. If you received this
in error, please contact us immediately and delete the material from any
computer.
Thank You.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<inline: graycol.gif>>
<<inline: ecblank.gif>>
<<inline: pic28351.gif>>
