Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Day Name from Date

Received Response
94
Views
5
Comments
slgott
slgott Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence

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

Tagged:

Answers

  • GopiKAutomus
    GopiKAutomus Rank 3 - Community Apprentice

    you can try updating the property of the column with BIN values and replace 1 - Sunday ,2- Monday etc.  That should work.

  • Nirmal-64675
    Nirmal-64675 Rank 2 - Community Beginner

    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

    Capture.JPG

  • slgott
    slgott Rank 4 - Community Specialist

    Thank you! It is not working in Sales Cloud. I will post to the Sales Cloud Analytics forum. Maybe it's a known bug.

  • slgott
    slgott Rank 4 - Community Specialist

    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.

  • GopiKAutomus
    GopiKAutomus Rank 3 - Community Apprentice

    Glad it worked. 

    Thanks,