**



You could do this with SQL within Remedy. This will return records from "Yesterday".
SELECT COUNT('Request ID') FROM WHERE 'Create Date' >= $DATE$ - 86400 AND 'Create Date < $DATE$

There are also "Date' type functions in pure sql.

Mark Blankenship
AVAYA

***
Hi, I want to calculate (not show) number of requests created 'yesterday', run by an al anyytime based on the ars-field 'Created'. Possible to use sql ..? (I know ars-dates and Oracle is a bit complicated). Is there another (fast) way than the sql-method? If sql can be used ..

For example, if the date is 2006-03-12 I want to get number of requests created > 2006-03-11 and < 2006-03-12

L ars Pettersson
Vattenfall Business Services Nordic AB
Action Request System Engineer (Tabasco)
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


This posting was submitted via the Web interface

Top