Need to pull time of day out of date time field and grab the first(minimum) occurrence for each day for each resource. For example 3 different assembly lines have "start" events throughout the day. I'd like to see the first one of each day on day shift to see if they are all starting up on time. I can do this against SQL using sql query tool but have been unable to do in crystal 11 against Oracle.
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Pulling time out of Date/Time
- Thread starter Gnrlwar
- Start date
Hi,
This is the forum for Enterprise issues not reporting ones, but:
Why not use your SQL as a Command in CR instead of using the tables?
You may want to post your issue in the CR Formulas forum:
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
This is the forum for Enterprise issues not reporting ones, but:
Why not use your SQL as a Command in CR instead of using the tables?
You may want to post your issue in the CR Formulas forum:
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question