Skip to main content

Want to show month value once for set of weeks fall under it, where my sort order should be as per week number 201944, 201945, 201946 and so on.

 

Is there any way that we can show colors and its month name populated once on it?

 

PFB issue,

 

Want to show month value once for set of weeks fall under it, where my sort order should be as per week number 201944, 201945, 201946 and so on 

1 answer
  1. Jan 2, 2021, 3:46 PM

    Have you tried DATEPARSE? DATEPARSE('yyyyMM', [Your Week Field]). Should be able to return the month from that. Best, Don

0/9000