In all criteria the date appears as 03/03/2015 03:56:13 PM. Is there anyway to remove the timestamp from the view so only the date appears in the columns?
Thanks!
Sara
You can format the data format using the column properties on the first tab.
Thanks - I already have tried this, but all the options in 'Date Format' do have the time included. I also tried Custom but it didn't work. Perhaps I am missing a step or something?
Check "Override Default Data Format", keep "Date Format"=Custom and then enter your format into the "Custom Date Format" field. I often use dd-MMM-yyyy which gives me 16-Mar-2015, a format that is generally understood throughout the world. Finally, click OK and it should work.
Hi Sara
Have you tried click on 'Data Format' tab in the column properties, ticking 'Override default data format', selecting 'Custom' as the date format and then typing the custom date format as dd/MM/yyyy? i.e. just removing the HH:mm from the format.
Jason
You can also change the date format in Fusion in "Set Preferences" > "Regional". After a little while, the format you chose should be applied in Answers.
Thank you so much!!
Perfect. Thank you so much!
Additional question regarding this issue:
Beyond just formatting, is there a way to actually restate the column so that is actually just a date? The data formatting is just cosmetic. I'm trying to do a Case statement on 2 date columns. When one is >= another, then I want it to show as "overdue". The problem is that it is taking the time into consideration. So if the dates are the same but the time is later than the other, it is showing as overdue when really I don't want it to (the business has until EOB to complete work).
Any thoughts on how to do this?
Thanks,
Stephanie
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
