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 Rhinorhino 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: natetc
  • Content: Threads
  • Order by date
  1. natetc

    Time and Date formula

    Hi, I have been using simple formulas for my reports and now my boss has asked to add time to this formula. Before: The requirement was to pull stats from yesterdays data, formula below: {W000001.DATETIME} = currentdate-1 Now: Requirement is to pull stats from 2 days ago at 4pm all the way...
  2. natetc

    Remove full duplicate lines

    I am very new to Crystal and usually use MS Execel. However, when outputting this report automatically I'd like for the report to remove duplicate lines, instead of surpressing them. How do I do that? Here is the example. Raw Data: Date-Time-Item-Account 3/16/2011 - 12:00PM - Orange - 001...
  3. natetc

    Simple Decminal Place Question

    Hi all, This is probably easy but I've spent 30 minutes in the Format Editor-Number-Customized menu and can't figure it out. My output is without decimal places and I require two in the field. However, I want to place it within the existing data, I know I can just add them to the end but...
  4. natetc

    Month formula

    Hi, Just looking for a simple month formula that will filter all data from the quarter. (ie last quarter from today Oct 16- Dec 16) {TABLE.KEY_DATE}=currentmonth -3 Hopefully there is a easy solution for this, thanks!
  5. natetc

    Formula to remove duplicates

    I don't know if this is possible but please let me explain and let me know if there is a formula for it. Here is a simple example, time=column 1, fruit=column 2 Time-Fruit 13:00-Apple 14:00-Oranges 13:00-Apple 15:00-Grape 16:00-Apple I want a formula that will remove the duplicate...
  6. natetc

    Date formula question

    Hi all, My question is how do I create a date/time formula that runs for the current/yesterdays business day. I want the formula to pick up data from yesterday 3pm to today 3pm. This is the formula I have in the system now: {ABC.EVENT_DATTIM} in DateTime (2010, 10, 27, 15, 00, 00) to DateTime...

Part and Inventory Search

Back
Top