Oracle Transactional Business Intelligence

Day Name from Date
Summary
Need to get the name of the day of the week from the Creation Date
Content
Hello,
I am using this function: DAYNAME("Service Request"."Creation Date") and it is not returnning the day NAME I would expect. It is returning a number. So for Sunday it returns "1", Monday, "2", and so on so forth. I don't want to display the day number of the day of week. i want to display the Name. Sunday, Monday, Tuesday, etc. Does anybody know how to do that?
Thanks,
Stephanie
Answers
-
you can try updating the property of the column with BIN values and replace 1 - Sunday ,2- Monday etc. That should work.
-
Hi Stephanie,
I tried the DAYNAME("Candidate Creation Date"."Candidate Creation Date") in Recruiting, it is working as expected. It is returning the day name as 'Fri', Sun'.
Thanks
Nirmal
-
Thank you! It is not working in Sales Cloud. I will post to the Sales Cloud Analytics forum. Maybe it's a known bug.
-
This is a great workaround. Thanks! I still think the function is not working as expected and that could just be a bug with the Sales cloud OTBI but your suggestion gets me what I need. Thanks again.
-
Glad it worked.
Thanks,