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

    How to use Current Date in a query?


      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