Thank you Fred. That worked.
On Wed, Jul 13, 2011 at 10:15 AM, Grooms, Frederick W <
[email protected]> wrote:
> I have always used the following for dates and the Mod operator ('Submit
> Date' - "01/01/1970") which is really doing ('Submit Date' - 0)
>
> Try
> ( ('Last Resolved Date' - (('Last Resolved Date' - "1/1/1970" ) % 86400))
> = ('Submit Date' - (('Submit Date' - "1/1/1970") % 86400)) )
>
> This should check that 'Last Resolved Date' (minus the seconds) equals
> 'Submit Date' (minus the seconds)
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList) [mailto:
> [email protected]] On Behalf Of Frank Caruso
> Sent: Wednesday, July 13, 2011 8:55 AM
> To: [email protected]
> Subject: Re: Created and Resolved Same Day
>
> ** Very ingenious approach and I can understand the math. However, I cannot
> get it to run. I've tried many different combinations and I keep getting
> "Data types not appropriate for relational operation" and "Data types not
> appropriate for arithmetic operation"
>
> I have narrowed it down to the adding of the Submit Date fields. If I
> subtract them (which I know is incorrect) the query runs.
>
> -----Original Message-----
> On Tue, Jul 12, 2011 at 7:26 PM, Thad Esser wrote:
> **
> Frank,
> WARNING: This isn't pretty.
> Here is your advanced search bar criteria for finding tickets that were
> resolved on the same day they were submitted:
> 'Last Resolved Date' < ('Submit Date' - ((('Submit Date' +
> 'Submit Date')/2) % 86400)) + 86400
> Explanation:
> * Using the modulus ("%") operator, we can find the number of seconds
> since midnight of the submit date. The trick here is that the user tool
> doesn't let you use the modulus operator on datetime fields. The
> "Submit_Date plus Submit_Date divided by two" tricks the system into
> thinking it's dealing with a number, and then modulus works.
> * Subtract the number of seconds from the original submit date/time to
> find midnight of the submit date.
> * Add 24 hours (86400 seconds) to find midnight of the next day.
> * If the ticket was resolved on the same day it was submitted, the Last
> Resolved Date will be less than midnight of the day after submission.
> Hopefully that helps,
> Thad Esser
>
> -----Original Message-----
> On Tue, Jul 12, 2011 at 8:40 AM, Frank Caruso wrote:
> ** HD 6.0
>
> ARS 6.3p24
>
> Using the Remedy User tool is there any way to query for tickets created
> and resolved the same day?
>
> We have create datetime and resolved datetime in datetime format only. I
> know I can do this for a single day but the user wants to run report each
> week.
>
> Thank you
>
> Frank
>
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
