5 Replies Latest reply on Nov 5, 2018 2:06 AM by Gaytri k

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

    Gaytri k

      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.