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!

Register Log in
  • Congratulations Shaun E 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: *

  • Users: JULY1
  • Content: Threads
  • Order by date
  1. JULY1

    Using UTC Date Time field in a Parameter

    I am trying to create a Parameter using a UTC Date Time field,{CallDetailRecord.dateTimeConnect}. This is a numberic field and I would like it to appear in the Parameter as a date and not numbers so that the Parameter will allow a Date Range. In the "Detail" area of my report I've created...
  2. JULY1

    Group by Time Range for Month with field using DateTime UTC

    I would like to group all my records for an entire month by time ranges. Such as all calls for the month of May made between the hours of 07:00:00 to 09:30:00. I am currently using the following formula to convert the UTC timedate field which is in seconds (example: 320,251,407) to a standard...
  3. JULY1

    USING IF -THEN -ELSE WITH PICTURE FUNCTION

    I am using the following as my formula for phone numbers: picture({CallDetailRecord.callingPartyNumber},"XXX-XXX-XXXX") My problem is that this is picking up our 5 digit extensions (ex. 15330) as 153-30-. How can I set up a formula to use the "XXX-XXX-XXXX" when there are...
  4. JULY1

    Numeric Time/Date field: DST and Leap Year ?

    I am currently using the following formula to convert the timedate field which is in seconds (example: 320,251,407) to a standard time and date (example: 5/1/2002 7:10:07AM). {CallDetailRecord.dateTimeConnect} / 86400 + DateTime (1969,12,31,20,00,00) Note: In the formula after the...
  5. JULY1

    Formatted "elapsed time" string - no days, increase hrs

    I found a formula to use that is helpful from Ken Hamady's web site. However I would like to edit it by doing away with the "days" and carry over that time to allow the "hours" portion to increase. Here is the formula I'm using: WhilePrintingRecords; NumberVar TotalSec :=...
  6. JULY1

    Time field (UTC) Sum won't exceed 23 hours

    I have been using the following formula and am unable to get a sum that exceeds at total of 23:59. Sum ({CallDetailRecord.duration}) + Time (00,00,00) What I want is the Sum to display the total duration of time spent on the phone by a department during a specified month. The total hours must...

Part and Inventory Search

Back
Top