How to change the day of week number to text... like Monday, Tuesday....etc?

[StephenW]

Dear ALL, would you please to guide me how to change teh day of week number to "Monday", " Tuesday"....etc? I have used the "WEEKDAY(Date)".... Thanks ALL. 

[GavinW]

I'm not an authority on calculated fields in Studio, but I popped your question into Gemini and it suggested creating a calculated field using syntax like this:

CASE WHEN DayOfWeek = 1 THEN "Sunday" 

WHEN DayOfWeek = 2 THEN "Monday" 

WHEN DayOfWeek = 3 THEN "Tuesday" 

WHEN DayOfWeek = 4 THEN "Wednesday" 

WHEN DayOfWeek = 5 THEN "Thursday" 

WHEN DayOfWeek = 6 THEN "Friday" 

WHEN DayOfWeek = 7 THEN "Saturday" 

ELSE "Unknown" 

END

You would presumably have to change 'DayOfWeek' to whatever field is giving you those day numbers.

[StephenW]

GavinW, Many thanks 🙏 I will try~