Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 16, 2018, 12:09 PM

Convert Week Number to dd/mmm - dd/mmm format

hi team,

 

i have a date field in my data. i would need to show weekly sales. so my client wants to keep the Heading in the format "30-sep to 06 Oct" that is dd/mmm-dd/mmm format instead of showing it as WeekNumber 40.

 

kindly help me how can i convert the Datepart(Week,"Sales Date") to dd/mmm-dd/mmm.

 

Thanks a lot in advance.

6 answers
  1. meenu choudhary
    Oct 16, 2018, 12:25 PM

    Hello Drish,

     

    You can try below approach:

     

    1. Week : DATENAME('week',[Order Date])

    2. start date : {FIXED [Week],YEAR([Order Date]):MAX([Order Date])}

    3. end date : {FIXED [Week],YEAR([Order Date]):MAX([Order Date])}

    4. week format

    STR(DATEPART('day',[start date])) +'-'+ LEFT(STR(DATENAME('month',[start date])),3)

    +" to "+STR(DATEPART('day',[end date])) +'-'+ LEFT(STR(DATENAME('month',[end date])),3)

     

    Hello Drish, You can try below approach: 1. Week : DATENAME('week',[Order Date])2. start date : {FIXED [Week],YEAR([Order Date]):MAX([Order Date])}3.

Write an answer...
0/9000