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 biv343 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: *

  1. WOWO10

    IF stmt and date comparison ...challenge

    I am using a specified date in a cell (C3) and comparing it to set dates to deterimine which rate table to use. However, I am not able to get C3 to be read as a date and compared as a date. I have tried formating the cell as a date any tips...
  2. WOWO10

    Comparing Dates in EXCEL IF STMT..HARD ONE!!

    I am using a specified date in a cell (C3) and comparing it to set dates to deterimine which rate table to use. However, I am not able to get C3 to be read as a date and compared as a date. I have tried formating the cell as a date any tips...
  3. WOWO10

    Sorting Dates with over laping date ranges

    Good Question......I think some data would help explain my dilema. Person Begin END Status Process John Smith 01/01/00 01/31/00 OPEN 02/02/02 John Smith 01/01/00 01/31/00 Suspend 02/03/02 John Smith 01/15/00 02/28/00 CLOSED 03/03/00 Off this I would...
  4. WOWO10

    Sorting Dates with over laping date ranges

    Thanks for replying, I hope this will clearify it. For this question none of the dates contain null values. The date range that I am looking at is Begin_Date Thru End_Date. Process_Date is just the date the status was determined.(Time Stamp)
  5. WOWO10

    Sorting Dates with over laping date ranges

    I have a table with the following Begin_Date, End_Date, Process_Date and Status I want to pic out the most current status for every date range. Some of the date ranges overlap. Any Ideas where to start?

Part and Inventory Search

Back
Top