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 Mike Lewis 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. STRookie

    Identifying data where month is not equal to specified month

    Hi there, I have a table with a column of dates in which I need to identify and isolate those dates that are NOT in Septemer. The data is formatted as num Date9. NIPR_EXP_DT1 8/31/2012 2/20/2012 9/18/2013 9/10/2013 9/10/2013 9/10/2013 9/5/2013 9/13/2013 6/30/2012 9/9/2013 Any help will be...
  2. STRookie

    Dates and if/then else

    Good afternoon, In a nutshell: we have a date range of 01/01/2011 and 01/31/2011. If the date in the Due date column is in the rnage the new date should be 12/31/2010. We've tried these three if/then steps so far with no luck: IF ' 01/01/2011'>=FAKE_DT<= ' 01/31/2011 ' then put '...

Part and Inventory Search

Back
Top