Day Name from Date

slgott

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

GopiKAutomus

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

Nirmal-64675

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

slgott

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

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

Glad it worked. 

Thanks,