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

    XXXX to year for calculation

    Hi Guys, this is probably an easy one, but I'm not sure how to quickly add in the information without having to create a table to hold the data. In the system I'm working with people are able to enter Holidays in a text field. Either 01/01/2011 for a specific date. or 01/01/XXXX if the date...
  2. ewithoud

    Stored procedure with Parameters?

    I have created a stored procedure which calculates the # working days between 2 dates taking into account a table with non working Holidays. In Crystal I want the result set of a report showing details to pass in two dates and get the result from the procedure to show the correct working days...
  3. ewithoud

    Calculate time between values in crosstab

    I need to create a crosstab that calculates the time between completion of tasks in a crosstab. see example below: task task 1 task2 task3 task4 date completed 26-May 15-Jun 25-Jun 20-Jul time between tasks 20 10 25 How do I calculate the time between...
  4. ewithoud

    check if URL is valid in excel?

    Hello All, I have a question. Currently I have built an excel list which creates hundreds of URLS based on the products our company sells (Deeplinks to products on our website) however I am not sure if all these links are actually valid/exist. is there a way within this excel sheet I can check...
  5. ewithoud

    What GIS system to use?

    I am working on a new project at work where I believe we need a GIS system. However I am getting a bit lost with all the different systems out there. As I am new to GIS I was hoping I could get some help here. The requirements we need are pretty basic, so I don't think we need a very expensive...
  6. ewithoud

    Concatenate cells using logic

    Hello, I have a question for excel. I am using a pdf scrubbing software to get PDF data. However the data generated is not the same as is usable for our system. Therefore it needs to be adjusted. The data looks as follows cell 1 Cell 2 our system XXX -YYYYYY-ZZ(Z)...
  7. ewithoud

    Variable length field not showing up in Crystal Reports

    I have a problem with getting a variable length field to display properly in Crystal Reports 10. I am working with CR10. Calling on a progress (mfg/pro) Database using ODBC (Datadirect 4.0). In the database I have some fields that have a variable length. When these are passed to Crystal it...
  8. ewithoud

    Variable length field only shows first 8 characters

    I have a problem with getting a variable length field to display properly in Crystal Reports 10. I am working with CR10. Calling on a progress Database using ODBC (Datadirect 4.0). In the database I have some fields that have a variable length. When these are passed to Crystal it will show as...

Part and Inventory Search

Back
Top