Worksheet issue whith exception filter
I am having an issue with the worksheet when exception filter is added in demantra 7.0.2.
case : The data is pulled in a worksheet with filter for a sku and an exception filter "ver_date". This series is an exception series with data type "date".
exception given was ver_date < 08/07/10 . when this exception is given the worksheet throws error stating ' no data found'. But in reality we have data in 09/12/2009 for that sku.
When we give a date till 2009, ex.: ver_date < 12/31/09. the worksheet pulls the data correctly. it is throwing error for any date >= 01/01/10. From my analysis , it seems to be a bug that the application is throwing error for any date in 2010 given in the exception filter .