4 Replies Latest reply on Jan 5, 2011 7:49 AM by cknott

    How to use Current Date in a query?

    Rookie

      I need to build a query to look for devices who haven't reported a Hardware scan within the last 30 days.  I'm new to this so any help would be great.  Here is what I'm looking for in "plain" english.  "Last Hardware Scan Date" > "30 days before current date."

       

      Ver. 8.8 SQL DB