OTBI Analysis - How to pass only Date for column that is having date and time
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):
Code Snippet (add any code snippets that support your topic, if applicable):