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

Recent content by Xenophobe74

  1. Xenophobe74

    using NVL and date fields

    Thanks Gary and thanks lbass. Both replies were helpful. lbass, I used the second option in your reply and it worked awesome. Thanks again for the help.
  2. Xenophobe74

    using NVL and date fields

    Here is a query I write in SQL*Plus that gives me exactly what I need in a report I am creating: select l.messaging_id,l.name,l2.name,p.pager_id, o.START_DATE, o.END_DATE, o.REMARK, from listing l, listing l2, on_call_assignment o, pager_assignment p where l.MESSAGING_ID =...
  3. Xenophobe74

    XI Current Date Time range

    That's exactly what I needed. Thanks for taking the time to respond so quickly. I try to figure things out on my own before disturbing the masses. I am a Oracle Database guy that has been thrown into creating Crystal Reports and Crystal is a little like learning a new language :( Thanks for...
  4. Xenophobe74

    XI Current Date Time range

    Hey guys, I am a newbie to this site and hope someone can point me in the right direction. I am creating a report that requires the output to report on any changes made to a system for the current date between the times of 8:00 AM and 3:30 PM. I am trying to use a function that will...
See more

Part and Inventory Search

Back
Top