Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

OTBI Analysis - How to pass only Date for column that is having date and time

in Reporting and Analytics for ERP 4 comments

Summary:


Content (required):

The below condition is failing as Application Creation Date is returning date with timestamp and Current_date is returning only date.

Application Creation Date is equal to / is in SELECT CURRENT_DATE FROM "Receivables - Standard Receipts Application Details Real Time"

How to have Application Creation Date return only date for comparison? We cannot use TO_DATE or TO_CHAR functions here.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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