5 Replies Latest reply on Jun 4, 2008 4:43 PM by msandlin

    Trying to create a report that tells me PCs that are over three years old.

    Rookie

       

      Hi All

       

       

      This is my first post here.

       

       

      I am using the query "Computer"."BIOS"."Date"  <  "05/12/2005". The report returns all computers with a BIOS date with the first 2 digits less than 05.

       

       

      In other words I think it is treating the date field as test rather than a date.

       

       

      Does anyone know how to use the date as a filter in a query to return "All computers with a Bios date more than 3 years old"?

       

       

      Jeremy