Help with OTBI Filter Error
SummaryError when filtering for a date range
Hello, I am having 2 issues.
1. I am trying to create a filter using Invoice Date where report would show all invoices for last 1 week. I am using the following SQL statement:
Select TIMESTAMPADD(SQL_TSI_WEEK, -1, CURRENT_DATE) from "Payables Invoices - Transactions Real Time"
When I select Invoice Date is equal to / is in I have a result.
When I select is greater than or equal to or is less than or equal to, I am receiving an error message.
Any idea what is happening?
|View Display Error|