Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cable1

    Dynamic Date Difference

    I figured it out! ApplySimple("dateadd(day, -90, #0)", ?P1)
  2. cable1

    Dynamic Date Difference

    The system will not subtract an int from a date. The whole problem is trying to figure out how to convert a date to 90 days before the entered date. I have played around with the DayofYear function in filters and derived metrics, but I still cannot get it to work. Thanks anyway.
  3. cable1

    Dynamic Date Difference

    I understand exactly what you are saying and this should work, but P1 is of type date and 90 is of type int. It will not subtract an int from a date. Is there a way I can use the DayofYear function to turn P1 into an int, subtract the two, and then turn that number back into a date? Thank you...
  4. cable1

    Dynamic Date Difference

    I want to take a prompt answered date, P1, subtract 90 days from P1 to get P2 and end up with a date range of P2 to P1. I have played with the following syntax, but I cannot figure out a way to replace P2 with (P1-90 days) since "90" is not of type "date". ApplyComparison...
  5. cable1

    EM Report Counting

    I am not finding the function parameter listing for the count function. Am I supposed to be modifying the function or the metric? Could you please be more specific as to how to change it to "true"? Thank you so much for your help!!
  6. cable1

    EM Report Counting

    How do you accurately count the number of reports, not the number of jobs, that a user has run over a certain period of time in EM? By running simple test reports, it is known that a job is NOT the same as a report. Running two reports may give a total job count of 4, when I really want to see...
  7. cable1

    Error when exporting to Excel

    When exporting a report to Excel, 40260 rows, it times out after exactly 2 minutes with the Export using plain text option. I have tried the guidelines in TN5600-7X0-0276, set the Request timeout to 3600 seconds, increased the JVM Heap Size to 256 MB, and increased the ASP Script Timeout/...

Part and Inventory Search

Back
Top