Enable the "Date From" and "Date To" fields to be calculated mathematically in a query

We encountered trouble in query when searching for constituent codes within a date range. For instance, say we have John Smith who is marked as Constituent Code>Major Donor from 1/1/2005 - 12/31/2011. We would like to pull all Major Donors Constituents from 1/1/2011 - 12/31/2011. In query when we try to search using the criteria filter "Date From is greater than or equal to 1/1/2011" and "Date To is less than or equal to 12/31/2011", the program is unable to calculate the date field and pull any constituent records. Reason being is because John Smith's "Date From" is 1/1/2005 and we are asking for dates great than 1/1/2011. Because 1/1/2005 is actually less than 1/1/2011, the program is unable to pull the record because it is treating/interpreting the field as a static date field rather than calculating the date fields mathematically.
A customer service rep. suggested we use "Date To" as the starting date (i.e. 1/1/2011) and while that works, then we eliminate our ability to use an end date within our query.
Please consider fixing this on the back-end and changing this field to calculate mathematically. Thanks!

  • Guest
  • Jul 18 2014
  • Attach files
  • Guest commented
    March 18, 2016 00:41

    Your query would work just fine if you used OR instead of AND between the two date ranges.