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.