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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

First Date/Time Entry on column with many entries

Status
Not open for further replies.

cathey04

IS-IT--Management
Mar 25, 2004
33
US
This is from thread 767-1408240 and it was resolved by adding a summary for each Time/Date field using maximum to get the oldest entry. My question now is how do I get minimum for the first Time/Date entry? Thanks
****************************
I am using CR10 and Oracle 9, HPUX os. The database is HP OpenView Service Desk, and I am pulling data from the service call and service call history fields view, and in the history view, each record has every single entry in the history. What is happening is when the data is returned there are several lines that repeat. I fixed that by formatting it to suppress duplicate fields, but now it shows up with one entry for the main part (service call), and then another line with the Accepted Date (formula), another line with the Accepted Date (formula), and Misrouted (formula), and Resolved (formula) So it looks like this when exported to Excel data (trimmed down)

ID Created Routed Accepted Misrouted Complete Close code
1 9/7 software
9/7
9/7
9/8
9/9

Then when it exports as different lines 1/1/00 comes up above the separate entries of Routed, Accepted, etc. Gosh I hope this make sense, if not, please let me know. I would attached the query and export but not sure if I can here.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top