You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help with OTBI Filter Error

Received Response
edited Mar 22, 2021 11:00PM in Reporting and Analytics for ERP 2 comments


Error 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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!