5 Replies Latest reply: Apr 8, 2015 10:42 AM by Sunny Talwar RSS

    Count Records Less than Date Selection in Listbox

      I've created a test file where I am attempting to count records less than or equal to a variable date value.  When a selection is made in the YearQuarter listbox, I want the count to include all records <= the variable vFPYQuarterEnd. 

       

      In the example, if you select 2014-3, the variable vFPYQuarterEnd = 9/30/2014 and all records less than or equal to this date should be counted, including those that do not fall within the the actual quarter.  I would expect to see a count of 12 records.  Instead, I am receiving a count of 9 records which represents on the records in the 2014-3.