Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Date format in OTBI Prompt
Summary:
How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024"
Content (please ensure you mask any confidential information):
In a OTBI Dashboard Prompt bases on Subjet Area "Workforce Management- Worker Assignment Event Real Tme"
I se the field "Assignment EventDetails"."Assignment Last Update Date" in a prompt. Here it appears as a timestamp date in the prompt.
I Want the promp to be in date format, without the hour-minute-seconds. It works fine with another date field like: "Assignment EventDetails"."Effective Start Date"
Version (include the version you are using, if applicable):
Oracle Fusion HCM
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0