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

    using null date values

    I have two tables joined together with a left outer join and am trying to use isnull(obsdate) to find records in the left table that are missing a corresponding record in the right table, with Obsdate being a date/time field in the right table. I am choosing "default value for nulls" in the...
  2. robhc

    converting date to YYYY,MM,DD

    Hi: I have a table with a date field in the format "1/1/2008" and need to use it in a date selection criteria. Unfortunately, you can see the lengths won't be a consistent MMDDYYYY so I don't see a way to totext it and use a mid formula to reconstruct it. Suggestions? CR - 11 user

Part and Inventory Search

Back
Top