5 Replies Latest reply on Oct 26, 2016 6:53 AM by David Li

    Finding Sunday's date using year/week number only




      I am assuming I need to use a mixture of DATEADD/DATEPART but not sure.


      So for example, I have a year column and week number column.  If year is 2016 and week number is 44, I need to calculate Sunday's date of that week.


      So taking today 25th October, the YEAR is 2016, WEEK NUMBER is 44, so the result should be Sunday's date... 30th October.


      Thanks in advance.