5 Replies Latest reply on Nov 5, 2018 2:06 AM by Drish D

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

    Drish D

      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.