1 Reply Latest reply on Feb 5, 2010 1:25 PM by LegoGuy

    Query Criteria for Creation Date Not Working as Expected

    Apprentice

      I have a query ( in 7.2.4) that is designed to pull up incidents that are coded in a certain way (there are 4 variables) AND fall between two dates.

      The query pulls up calls that meeting the first set of critera, but does not exclude incidents that fall outside of the range indicated.

       

      Attached is a pdf of the critera I select. I am basing this query on the incident table.  Any insite will be greatfully received.