Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 182 Oracle Analytics News
- 39 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 62 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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.
0 -
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
0 -
Thank you! It is not working in Sales Cloud. I will post to the Sales Cloud Analytics forum. Maybe it's a known bug.
0 -
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.
0 -
Glad it worked.
Thanks,
0