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

    Retrieving pricing for the most current Effective date

    I have a table that is storing pricing with an effective-date, but no end-date. I need to get the pricing for the most recent effective date and I have been struggling to find a solution in CR2016. Below I am providing an example of two SKU's with different effective dates and they also have a...
  2. klgoist

    Current pricing record

    I have an SQL Database(Progress Openedge) and I am using Crystal reports XI r2 I have a table(prod_price) with the following sample data, and I am trying to do an "Add Command" in Crystal, where I am only grabbing the records for the currently active price records. In the future, as prices are...
  3. klgoist

    Replacing consecutive zeros in a string with a period

    I have a string field that is 17 characters long. (example: 04000000000000039 or 04000000000010439). I would like to replace the zeros between the 4 and the next non zero character with a period. (Example: 04.39 or 04.10439) Is there a simple formula for doing this?

Part and Inventory Search

Back
Top