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.



      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"?