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
16
Views
2
Comments
edited Mar 22, 2021 11:00PM in Reporting and Analytics for ERP 2 comments

Summary

Error when filtering for a date range

Content

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?

 Error
  View Display Error
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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