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
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
