Re: Finding minumums

[Deb Maynard <Debra_Maynard@DOT.CA.GOV>]

Thanks for the help so far...I've made some huge progress on this stuff...but,
I'm still having problems.  I've now successfully got my start and stop times
substrung properly from the 'comments' field into variables: $start_tm and
$end_tm.  So, I've got a list for each employee for each day.  How do I evaluate
all of the values and choose the min $start_tm and max $end_tm.  I know what
you're thinking "I already told her!" but I'm a bit confused about how I should
tackle this.  For instance, one employee has 4 values for $start_tm for a single
day.  They are: 0800, 1000, 1400, 1500.  I need the 0800 and that's it.  Does
anyone have a suggestion?

Thanks so much!

Deb





Deb Maynard <Debra_Maynard@DOT.CA.GOV> on 10/05/99 08:17:23 AM

Please respond to SQR-USERS@list.iex.net



 To:      Multiple recipients of list SQR-USERS
          <SQR-USERS@list.iex.net>

 cc:      (bcc: Debra Maynard/HQ/Caltrans/CAGov)



 Subject: Finding minumums







Hello,

I am new to the SQR arena and I am pretty lost.  I can do your basic selects and
data manipulation, but I've just been assigned to a report modification that may
be a little out of my league, so any and all help would be extremely
appreciated.  The client I'm working for has captured time data from one system
and interfaced it into a 'comments' field in a PeopleSoft table.  A typical row
looks something like this:  800-1500--TRC: REG--HRS: 7 (start time, end time,
time reporting code, number of hours).  What I need to do is capture the start
and end times and print them on the report. I have almost successfully done this
using substrings (it gets tricky because some start times are 3 digits, some 4).
The problem is, sometimes an employee has multiple rows, one containing the
actual start time (the minimum of all of the start times) and another containing
the actual end time (the maximum of all of the end times).  Is there a way I can
evaluate the substring variable and only select and print the one I need?  I
assume there is, but it definitely wasn't covered in my SQR class!

I hope my explanation was clear.  Please offer any help you can!  Thanks.

Deb