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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by STRookie

  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