Bugs in Custom Report Criteria
Posted: Sun Jan 02, 2011 4:02 pm
There seems to be a problem in the report criteria for custom reports. I was trying to make a list of members with expired recommends or whose recommend will expire soon.
I used "Temple Recommend Expiration Date was in last 999 years, or Temple Recommend Expiration Date is in next 6 months". Instead, I got a list of all recommends that expire after today. If I switch the order, I only get the dates in the past.
Both filters work correctly independently.
I also tried with a few other date ranges and fields and received similar results.
Can anybody else confirm?
Also, some features that would be nice:
Allow more relative criteria, such as "Before today" or "After Today".
I would also appreciate a way to write SQL-like queries, as that would allow much more fine control.
I used "Temple Recommend Expiration Date was in last 999 years, or Temple Recommend Expiration Date is in next 6 months". Instead, I got a list of all recommends that expire after today. If I switch the order, I only get the dates in the past.
Both filters work correctly independently.
I also tried with a few other date ranges and fields and received similar results.
Can anybody else confirm?
Also, some features that would be nice:
Allow more relative criteria, such as "Before today" or "After Today".
I would also appreciate a way to write SQL-like queries, as that would allow much more fine control.