Extract day name from date parameter for text/title

Question & Answer
, ,
1

Is there a way to extract the day name from a date parameter?

I have a dates as title for a set of graphs which are relative to the current date. I want to include the name of the day in the title which updates with the date.

image
image3020×246 14.6 KB

2

Currently using a table visual with a calculated field to extract the day name as a workaround title.

image
image1048×204 3.38 KB

3

Hi,

Use this code in calculation field this will help you.

switch(extract(‘WD’,{YourDate}),1,“Sunday”,2,“Monday”,3,“Tuesday”,4, “Wednesday”, 5, “Thursday”, 6, “Friday”, 7, “Saturday”,“”)

regards,

Naveed ali

1 Like
4

Thanks! That is currently how I’ve made the calculated field

1 Like
5

Current workaround that I am using:

switch(
   extract('WD', ${relativeDateParameter}),
    1,'Sunday',
    2,'Monday',
    3,'Tuesday',
    4, 'Wednesday', 
    5, 'Thursday',
    6, 'Friday',
    7, 'Saturday',
    ''
)

I have several relative date parameters set to each day for the last seven days from the current date, which allows for the workaround titles to adjust relatively and match the visuals.

image